Apple Numbers for same cell, how to get two conditional formatting: one for cell color and another for text style?

Are you using the "mountains and sun" icon to upload your pictures?

So if the cell has the word "Stock", you want the cell to be blue? And so on for the other conditions based on the text in the cell? If this is your request and if you know how to make one of these conditional highlights, the others are just as easy to make. Use the "Add a rule" button to create additional rules.

Hi Sunnyintoronto123,

Your question is vague.

Do you want to show this with Conditional Highlighting?

Until you post a Screen Shot of your table, I am unable to help further.

Your original post shows your profile as iPhone.

Your most recent post says that you are using iPad.

Please ask the people in the iPad forum how to take a Screen Shot : iPad - Apple Community

Or the people in the iPhone forum: iPhone - Apple Community

More information may help us to help you.

Regards,

Ian.

Just to be clear on what you are doing to post an image, are you doing this:

1. Take a screenshot of part of your screen using Command Shift 4.
2. When crafting your post, click on the "mountains and sun" icon. A window will pop up letting you select a file.
3. Select your screenshot image file
4. Click Upload. The image should appear in your post.

For your first question, make two rules for the cell. One that applies background color when the cell meets your criteria and another that applies a text style when it meets a different criteria. Or the second one might be a custom format of color + style if that is what you had in mind. Note that it will apply whichever rule it gets to first that meets its criteria. If your first rule is cell color when the cell is >1 and the second is bold text when it is >2, it will never get to that second rule. You have to rearrange them so >2 is first then >1.

I do not understand your second question about "to allow same cell text style applied by another rule".

I understand your solution is to define rule for each combination of words. For my example, there will be four rules using your method.

I was thinking of using a word to define a rule to minimise rule count to two.

Thanks for useful suggestion; I

however in reality I have five lists. List 1 has 3 items; list 2 has 2 items; list 3 has 2 items, list 4 has 5 items.

it takes time to create rules for my case.

Blue Fill for Stock. Red Fill for Fund.

Black Text for Interest. White Text for Price.

We are not looking over your shoulder. A screen shot will allow us to see what you see.

I have been unable to upload pics. Is there alternative?

here it is

I cleared Safari Cookies and history but still cannot upload. This problem started half a year ago,

thanks. i am using ipad. screenshot whether original nor shrinked file size will upload but does not appear in post. i tried restart and reset safari cookies and history

I can upload to other support site

https://www.reddit.com/r/apple/s/QrqNNlxBPH