I have:

E3 F3 G3
Start Date Target date Completion date
1/01/05 1/30/05 2/01/05 (cell red,
after target)

WHEN I ENTER TARGET DATE, G3 TURNS GREEN. I NEED G3 TO "ONLY" TURN A COLOR
"IF" A DATE IS ENTERED IN G3. THE DATE ENTERED IN G3 WILL DETERMINE WHAT
COLOR G3 WILL BE.
AGAIN, PROBLEM IS: G3 TURNS A COLOR WHEN I ENTER DATE IN F3. I WANT G3 TO BE
"NO" COLOR UNTIL A DATE IS ENTERED.



"Ian" wrote:

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