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?
|