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.

numbers

In the app Numbers I use 2 colors in a sheet. Is there a possibility to catorgarise debit and credit in an automatic color mode? To color the cell or text in green and red.


Thanx Paul, NL

Posted on Feb 6, 2022 2:04 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 6, 2022 3:03 AM

You can use Conditional Highlighting to do this.


Select the cells and click the Conditional Highlighting button in the Cell tab under Format.




Click add a rule:




And set up the rules like this:




There are a lot of formatting options, i.e. red text instead of red background, etc.


SG

2 replies
Question marked as Top-ranking reply

Feb 6, 2022 3:03 AM in response to babeliowsky

You can use Conditional Highlighting to do this.


Select the cells and click the Conditional Highlighting button in the Cell tab under Format.




Click add a rule:




And set up the rules like this:




There are a lot of formatting options, i.e. red text instead of red background, etc.


SG

numbers

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