Thread: Conditional Formatting based on date passed

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

Select B3:B8, Format > Conditional Formatting (or the 2007 equivalent), Formula is:

=and($B$2 < today(), isblank(B3))

Thanks shg,

Formula works great.

Mike

You're welcome, glad it worked for you.