How to change cell color with reference to a formula?
 

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?

How to change cell color with reference to a formula?
 

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?

How to change cell color with reference to a formula?
 

Check here. http://www.mcgimpsey.com/excel/conditional6.html

They mention a way to have 6 conditions by using conditional formating and
custom formatting codes.

"Bob Phillips" wrote:

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?

How to change cell color with reference to a formula?
 

since you have 3 colors other than white, the white (probably automatic)
would be your default and you can use conditional formatting as is.