How to change cell color with reference to a formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Soumadip - 19 Jan 2006 17:58 GMT

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?

Reply to this Message

Bob Phillips - 19 Jan 2006 18:50 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> I want to change the color of a cell with conditional formatting.That means
> the
[quoted text clipped - 5 lines]
> The problem is in conditional formatting we can use only 3 formulas.So how
> to do it?

Reply to this Message

mikebres - 20 Jan 2006 01:01 GMT

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.

> You only have three real conditions, your default is white, so just setup CF
> for the first 3 conditions.
[quoted text clipped - 9 lines]
> > The problem is in conditional formatting we can use only 3 formulas.So how
> > to do it?

Reply to this Message

David McRitchie - 20 Jan 2006 20:18 GMT

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

Reply to this Message