Let's start from the beginning.

I selected *only* cell A1 when I entered this CF, and it (A1) worked as
advertised.

Did you only have A1 selected when you entered this CF?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


wrote in message
oups.com...
Hi RD,
Grrrr, I'm not sure why the cell keeps changing color even though I
haven't typed anything into cell. I copied your formula into the
conditional formatting field and chose my format. I hit OK and the
cell turned green (the format for my cell background).

I tried it on a brand new workbook and I'm using Excel 2002, SP3.
Maybe MS site will have info on why the condition is firing when only
one half of the formula is true.

Thanks again for your help.
Russ