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.