Colored cells based on dates

  • Thread starter Thread starter Sif
  • Start date Start date
S

Sif

I am dealing with two columns of dates. The first Column
is "date due", the second is "date received". If the "due
date" is today's date or eariler and the
corresponding "date received" is empty, I would like to
shade the "due date" cell yellow. However, when I enter
the corresponding "date received" in the cell next to it,
I would like the yellow shading reset back to the standard
white. Is it possible to do this?

Thanks,
Sif
 
Look at Conditional Formatting in the Format menu.

Condition 1 would be something like:

=AND(C6<=TODAY(),D6="")

Contrition 2 would be something like:

=AND(C6<=TODAY(),D6="")

Set format to suit your taste.

HTH

PC
 
Back
Top