Assume the cells ar A1:A4, select A1:A3 with A1 as the active cell,
formatconditional formatting formula is, for the first condition use

=ISNUMBER($A$4)

format button and select blue patterns/fonts, click OK and click add,
condition 2

=AND(ISNUMBER(A1),A1TODAY())

format button and select red patterns/fonts, click OK and click add,
condition 3


=AND(ISNUMBER(A1),A1<=TODAY())

format button and select green patterns/fonts, click OK twice

select A4 and use the same as condition 1

=ISNUMBER($A$4)


there is no good way of knowing that a cell holds a date so isnumber is the
closest you can get


Regards,

Peo Sjoblom


"Aviator" wrote:

I have 4 cells. Below is what I am trying to accomplish. I need the formulas
for each of the conditions. Please help.

Condition for Cells 1-3
Condition 1: If date is greater than NOW() - Red
Condition 2: If date is less than NOW() - Green
Condition 3: If there is a date in cell 4 (over ride conditions 1 and 2) -
Blue

Condition for Cell 4
Condition 1: If there is a date in cell 4 - Blue

Thank you,

Aviator