I tried this and the font was black (default colour) when A1 is blank.

Set the font colour in your cell to match the background colour.

Also, from your conditions, what should happen if A1=1 or A1= 1.995 (ie the
"holes" in the sequence)?

I'm guessing what you are looking for is:
condition 1 has a value but less than 1
condition 2 is 1 or more, but less than 2
condition 2 is 2 or more

If so your formulae should be for conditions 2 & 3 should be
=And(A1 =1, A1 < 1.99) and
=(A1 =2)

--
Ian
--
"Matt" wrote in message
...
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.