Hi All,
I was hoping to find out if there is a way to have more than three contions for conditional formatting in excel 2003.
I have a validation list in column B with 7 text options. Is there a way to condition format these to cell fill as follows
Text1 - Light Orange
Text2 - Green
Text3 - Red
Text4 - Pink
Text5 - light Green
Text6 - Blue
Text7 - Orange
Any help greatly Appreciated
Kind Regards
Kempy
I was hoping to find out if there is a way to have more than three contions for conditional formatting in excel 2003.
I have a validation list in column B with 7 text options. Is there a way to condition format these to cell fill as follows
Text1 - Light Orange
Text2 - Green
Text3 - Red
Text4 - Pink
Text5 - light Green
Text6 - Blue
Text7 - Orange
Any help greatly Appreciated
Kind Regards
Kempy