Conditional Formatting

[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?

 

[Domenic]

Hi Gina,

Assuming your two columns are A and B, try,

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

Hope this helps!

 

[Gord Dibben]

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

 

[Gina Corey]

Thanks! That worked.

Hi Gina,

Assuming your two columns are A and B, try,

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

Hope this helps!