Conditional Formatting with Icon Sets - traffic light - Not turning the correct colour

[drumfin]

Hi

I have used a conditional format for "icon sets" in Excel 2013 the traffic light option.

Green >= 100, Orange >=80 Red <80

All worked fine on my first sheet however, when I tried to repeat it in 2 more sheets (in the same workbook) the green and orange are appearing red.

Has that happened anyone else?

Was there any fix?

 

[Special-K99]

Works fine for me.

in A1 put 120
in A2 put 90
in A3 put 75

So Im expecting (reading down the column) Green Yellow Red

Condtional Formatting
Format Style: Icon Sets
Change Type to Number
For green value enter 100
Tab to yellow value enter 80
Red value automatically goes to < 80
Click OK.

Spreadsheet is Green yellow red when reading down

 

[drumfin]

Thanks I still had issues and I'm not sure why but when it worked on one cell I simply used format painter and it seemed to solve what I needed.

Works fine for me.

in A1 put 120
in A2 put 90
in A3 put 75

So Im expecting (reading down the column) Green Yellow Red

Condtional Formatting
Format Style: Icon Sets
Change Type to Number
For green value enter 100
Tab to yellow value enter 80
Red value automatically goes to < 80
Click OK.

Spreadsheet is Green yellow red when reading down