Hello All,
Using Excel 2007.
I'm trying to apply conditional formatting (red fill color) that looks at the date in B2 (formatted as date 6/26/08.) If the date is less than today (which it is) I want to apply a red fill color in B3:B8 ONLY if the cells are blank. In the attached example I want it to fill in red the cells B5, B6, B7 and B8 because the cells are blanks.
Trying to write a formula in conditional formatting but can't come up with one.
Any help would be appreciated. Thanks.
Mike
Bookmarks