Hello,
I am looking to have conditional formatting color cells containing a formula/text white/blank.
I currently have a sheet that colors approaching dates either red, green, or yellow based on their distance from TODAY(). This is working well but I would like any cell that doens't contain a date to remain filled white. I'm not exactly sure the best way to accomplish this so I am asking this very helpful forum.
Conditional Formatting Help.xlsx
I have attached the sheet that I am working with, feel free to ask any questions.
Simplified: I would like to exclude cells that do not have a date from this formatting.
Bookmarks