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
Sort By: 
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

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

numbers

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