HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?
 

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

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,"color 6","No color"))))))

Good luck

"HELP NEEDED" wrote:

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

That won't work

--
Regards,

Peo Sjoblom


"jennifer" wrote in message
...
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,"color 6","No
color"))))))

Good luck

"HELP NEEDED" wrote:

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

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"jennifer" wrote in message
...
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,"color 6","No
color"))))))

Good luck

"HELP NEEDED" wrote:

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