Conditional Formatting

  • Thread starter Thread starter Gina Corey
  • Start date Start date
G

Gina Corey

I have two columns that have date information. I want one
column to change to red IF that date is >= today() and if
the column next to it is blank. I have figured out how to
do one condition or the other, but not combined. The
online help only shows a single condition example.

Any Ideas?
 
Hi Gina,

Assuming your two columns are A and B, try,

Formula Is: =(A1>=TODAY())*(B1="")

Hope this helps!
 
Gina

Assuming column A is to be formatted and has dates, column B has data or
blanks.

Select column A and Format>Conditional Formatting>Formula is:

=AND($A1>=TODAY(),$B1="")

Format to Red pattern and OK your way out.

Gord Dibben Excel MVP
 
Back
Top