Colored cells based on dates

[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

 

[Paul Corrado]

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