JP, I think the semicolon after "TODAY()" was a typo, so I changed it to a
comma, and it worked great. Also, the tip about conditions working
sequentially is good to know (which I didn't). Thanks very much!!

"JP Ronse" wrote:

Hi Marie,

try something like

=AND(G3<TODAY();G30)

AFAIK, conditions are handled sequentially, so the second condition is
skipped when the first met the criteria.

Wkr,

JP
"Marie FP" wrote in message
...
I'm using conditional formatting to change the color of a cell to blue if
the
date entered in that cell is less than today's date. The formula works
fine
as long as there's any date in the cell. The problem is when the cell is
empty, it is also turns blue, but I would like it to have no formatting.
I
tried to fix this by adding a second condition, but it still didn't work.
Does anyone know how I can fix this? My conditions look like this:

Condition 1: Forumla Is =G3<TODAY() --- color is blue.
Condition 2: Cell Value Is equal to 0 --- color is no color