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

drumfin

New Member
Joined
Apr 21, 2016
Messages
10
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?
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
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

New Member
Joined
Apr 21, 2016
Messages
10
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,472
Messages
5,596,354
Members
414,060
Latest member
hermanseck

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top