I said, "Cell C2 needs to stay blank if C2=""" I meant that if there's no
data in C2, not to format G2 at all.
--
I would give my left hand to be ambidextrous!


"Dax Arroway" wrote:

Help with conditional formatting please. I'm designing a "tickler" sheet to
get cells to color by comparing itself to the date of another cell. There's
4 different conditions. I'm using Excel03 and there's only 3 available
conditions. Here's what I need to do.

Cell C2 has a Date.
Cell G2 needs to stay blank if C2=""
Cell G2 needs to turn blue when C2 is beyond 20 days past G2
Cell G2 needs to turn red when C2 is beyond 30 days past G2 --AND--
Cell G2 needs no format if any text is present in G2

I've figured:
Condition 1 in G2 is =$G2="*" No format (I'm using * as "any text" but I
don't think that's right)
Condition 2 in G2 is =$C2+30<TODAY() Color Red
Condition 3 in G2 is =$C2+20<TODAY() Color Blue
And I need one more condition, a Condition 0, which would be G2 is =$C2=""
no format.

If there's another way, please help.
Maybe Condition 1 could be: If C2 is blank OR if there's text in G2, don't
format. But I don't know how to write that in code-speak. Am I even on the
right track??

Thanks in advance!
--Dax

--
I would give my left hand to be ambidextrous!