ssblue
asked on
Excel conditional formatting blanks
See Attached sheet.
I have placed conditional formatting on a date column to change colors as the date gets closer to today.
However I would like for the BLANK cells to remain unformatted. So if there is nothing in the cell or it is blank then it should not have any formatting on it - it should be white with black text.
HoneyDoList.xlsx
I have placed conditional formatting on a date column to change colors as the date gets closer to today.
However I would like for the BLANK cells to remain unformatted. So if there is nothing in the cell or it is blank then it should not have any formatting on it - it should be white with black text.
HoneyDoList.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!!
Add a rule
Format only cells that contain
Format cells with Blanks
(No Format Set) OK
place the rule at the first line with arrows and Stop if true
Regards