View Single Post
  #1   Report Post  
Masatami
 
Posts: n/a
Default Formatting cells Auto fill color using €œIf€

I have the following formula in a cell:
=IF(Q28<0.65,"BLACK",IF(Q28<0.85,"RED",IF(Q28<1,"Y ELLOW","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,"Y ELLOW","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.