You get a red fill when the cell is empty--no space, no formula, no nothing???

I don't in xl2003.

Are you "clearing" the cell by using a space character? If you are, stop it
<vbg. It'll cause more problems down the road.

But you could modify your formula:
=AND(ISNUMBER(A1),(A11.99))

Matt wrote:

I have a 3 condition format on a cell. They are as follows.

Condtion 1: =And(A1 0, A1 < 1) If true, format to color green.

Condtion 2: =And(A1 1, A1 < 1.99) If true, format to color yellow.

Condtion 3: =(A1 1.99) If true, format to color red.

All three conditions work fine when a value is entered into A1 however when
the cell is blank, the font defaults to red. I want it to have no color when
no value is entered.

Does anyone know how to do this? Any help is greatly appreciated.

Thanks,

Matt.

--

Dave Peterson