Masatami

Are you saying that with that formula the cell background color actually
changes to red or black or green or yellow?

How do you do that?


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 14:09:02 -0800, "Masatami" <Masatami
@discussions.microsoft.com wrote:

I have the following formula in a cell:
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1," YELLOW","GREEN")))
I am attempting to change the color of Green to Bright Green. I assumed
changing the formula to:
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1," YELLOW","BRIGHTGREEN")))
would work but in changing the formula resulted in a Black filled cell not
bright green.

If some one could advise how to change to a different color it would be
appreciated.