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.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

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.