How do I color 3 rows at the same time using 'Open' in Apple Numbers?

Hello

I know how to apply 1 box color. Is it possible to color 3 rows at the same time if I type the word "Open"

Thanks Ryszard




[Re-Titled by Moderator]

MacBook Air 13″, macOS 15.4

Posted on Apr 24, 2025 8:34 AM

Reply
2 replies
Sort By: 

Apr 24, 2025 5:42 PM in response to ryszard242

To highlight an entire row using Conditional Highlighting you can do something like this.


Add an extra "helper" column, which you can later hide, with a formula like this:



The formula in D2, filled down:


=IF(C2="Open","","~")


If your region uses ; as the decimal separator use this instead:


=IF(C2="Open";"";"~")


Then select all the body cells in columns A through C (in my example: A2:C10) and apply a Conditional Highlighting rule like this:







To get that $D2 first click the box-and-arrow icon then click cell D2 in the table. Be sure to select the $ Preserve Column anchor.




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.

How do I color 3 rows at the same time using 'Open' in Apple Numbers?

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