You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

IF statements.

Hi Guys,

Is it possible to change the colour of the text in a cell if the value in it is above a certain value? i.e. "IF" A1 is >20 then red as opposed to default black.

Is it possible to change the colour of the text in a cell if the value in a different cell is above a certain value? i.e. "IF" A1 is >20 then C2 is red.

Regards

Mike

MacBook Pro 15″, macOS 10.13

Posted on Nov 18, 2022 3:03 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 18, 2022 3:47 AM

Hi Mike,

that would be done with Conditional Highlighting

There are some helpful videos on YouTube, search for "apple numbers conditional highlighting"


https://www.youtube.com/watch?v=-4wn6-f4gRg


It is easy to change the format based on the content of the cell itself.

Unfortunately it get complicated if you want to reference other cells.


Regards

Ralf


4 replies
Question marked as Top-ranking reply

Nov 18, 2022 3:47 AM in response to mikofpoole

Hi Mike,

that would be done with Conditional Highlighting

There are some helpful videos on YouTube, search for "apple numbers conditional highlighting"


https://www.youtube.com/watch?v=-4wn6-f4gRg


It is easy to change the format based on the content of the cell itself.

Unfortunately it get complicated if you want to reference other cells.


Regards

Ralf


IF statements.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.