User profile for user: HP1531
HP1531 Author
User level: Level 1
4 points

How can I highlight cells based on multiple conditions on Numbers app?

I'm coming from Excel and struggling to have conditional highlighting rule applied to multiple cells with multiple conditions. I tried using a "helper cell", but my formula and/or combinational highlighting rule does not have the desired outcome.


I would like to check the date column, if the date is today or earlier and any cell in columns B - E are empty, highlight the empty (blank) cells.


Thank you.



[Re-Titled by Moderator]

MacBook Air (M1, 2020)

Posted on Apr 16, 2025 6:49 AM

Reply
2 replies
Sort By: 
User profile for user: Badunit
Badunit
User level: Level 7
29,352 points

Apr 16, 2025 8:12 AM in response to HP1531

(Edited from original post)


Formula in cell F2 =IF($A2≤TODAY(),"","~")

Fill down


The highlighting rule is as shown in the screenshot. Select the range of cells that need the highlighting rule (B2:E8 in your screenshot, B2:E5 in mine) and do them all at one time. To get the $F2 in the rule, click the green oval (you'll see it when you are setting up the rule), click on cell F2, change it to $F2 to preserve the column, click the green checkmark to accept it.


Reply
User profile for user: HP1531
HP1531 Author
User level: Level 1
4 points

Apr 16, 2025 11:42 AM in response to Badunit

Badunit,


Thank you. I was making this more complicated trying to use AND in my formula (both blank and date earlier than). To be honest, I'm not sure I completely understand the "Text is" rule and how it's impacting the blank cells. All I know is your formula and highlighting rule work for my situation and I greatly appreciate your help.

Reply

How can I highlight cells based on multiple conditions on Numbers app?

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