View Single Post
  #2   Report Post  
jennifer
 
Posts: n/a
Default

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?