HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?

H

HELP NEEDED

I WOULD LIKE A CELL TO RETURN A DIFFERENT COLOR FOR EACH OF MY SIX
CRITERIA,ANY IDEAS?
 
J

jennifer

nested if statement

substitute appropriately; assuming trigger is in cell H1
=IF(H1=1,"color1",IF(H1=2,"color2",IF(H1=3,"color3",IF(H1=4,"color4",IF(H1=5,"color5",IF(H1=6,"color6","No color"))))))

Good luck
 
P

Peo Sjoblom

That won't work

--
Regards,

Peo Sjoblom


jennifer said:
nested if statement

substitute appropriately; assuming trigger is in cell H1
=IF(H1=1,"color1",IF(H1=2,"color2",IF(H1=3,"color3",IF(H1=4,"color4",IF(H1=5,"color5",IF(H1=6,"color6","No
color"))))))

Good luck
Click to expand...
 
J

JulieD

Hi Jennifer

this formula will return the literal text statements "color1", "color2" etc
rather than colouring the cells like conditional formatting would do (format
/ conditional formatting). Unfortunately, a formula can not change the
formatting of a cell. The only options are the ones that Peo mentioned or
the use of VBA.
 
Top