I have a column with dates that I need to turn red with conditional formatting when date is past 30 days. Also I need it to ignore the blank cells so it doesn't automatically hightlight them. So far I have a conditional format with formula: =D2+30<TODAY(). I also added the conditional format of Fomat only cells that contain Blanks then selected formatting of no color and also tried white, but it is still not working. Is there a better way of doing this? Thanks in advance for your help.
Bookmarks