Numbers: Multiple conditional row colors

I folks,

I'm on a MacBook Air M4, using Numbers.

This seems like such a basic thing to do but I just can't get the rule or formula correct.


I would like the whole row to change colour based on the contents of a cell. I have tried making all kinds of formulas with the help of Gemini but it never works correctly for more than one colour.


So I want the

Row background to be Green if the Type = Income

Row background to be Red if the Type = Expense

Row background to be Grey if the Type = Bank Transfer


Thanks for the help!

Sylvia


Posted on Dec 15, 2025 7:00 AM

Reply
2 replies

Numbers: Multiple conditional row colors

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