Forum Discussion
Conditional formatting but ignoring the blank cells
Hello, Thanks in advance for any help! I am trying to set some conditional formatting which I know how to do, but when I enter what I want it to mark the cells as it includes cells with no e...
Hi Penny,
please find attached my suggested solution. I have created extra columns for each condition, and used LEN() function to capture empty cells (as an alternative, you can also use ISBLANK()). Then I have created conditional formatting for each of the conditions and applied to the due date column in the order starting with 'Overdue', then 'Due Next 7 days', 'Due in 2 weeks' etc. For each condition I have ticked the box to 'Stop If True'.
Hope this helps
Regards
Yury
- Hi Yury,
Thank you so much for that, it is exactly what I needed!
Have a good day!
Kind Regards
Penny
