You only have three real conditions, your default is white, so just setup CF
for the first 3 conditions.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Soumadip" wrote in message
...
I want to change the color of a cell with conditional formatting.That
means
the
cell color Value
Red 0-97
Yellow 97.01-99.99
Green 100
White the cell is blank
The problem is in conditional formatting we can use only 3 formulas.So how
to do it?