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