Assuming your cell is B2 and the target date is in A2. Use "Formula is" and
enter

for on target
=AND(B2<"",B2=A2)
for ahead
=AND(B2<"",B2<A2)
for past
=AND(B2<"",B2A2)

--
Ian
--
"DONNA" wrote in message
...
I have a spreadsheet. I need a cell to turn
yellow is date is on target,
green if date is ahead of target date
RED if date is past target date.
AND I NEED THE CELL TO STAY WHITE IF I DO NOT PUT A DATE IN CELL.
It seems to me that I need four conditions. PLEASE HELP IMMEDIATELY.
THANKS