Icon Set Traffic Light Colours

[GDunn]

Is it possible to change the traffic light colours on Icon Style: 4 Traffic Lights?
I would like to change the black light to white, if possible.

Thanks in advance

 

[mfexcel]

The answer to your question is YES if you need a White Circle.

Icon sets offer limited choice of icons for selection.

Once you applied the CF,

1. Select the range with the CF --> Conditional Formatting --> Edit Rule
2. From there you should see the four icons being used for different conditions.
3. You may change the ICON by clicking on the drop down arrow next to it.
4. Change the Black Circle with Boarder to White Circle (All White Quarters)

Is it possible to change the traffic light colours on Icon Style: 4 Traffic Lights?
I would like to change the black light to white, if possible.

Thanks in advance

 

[GDunn]

"The drop down arrown next to it" does not seem to be available in MS Excel 2007.

The answer to your question is YES if you need a White Circle.

Icon sets offer limited choice of icons for selection.

Once you applied the CF,

1. Select the range with the CF --> Conditional Formatting --> Edit Rule
2. From there you should see the four icons being used for different conditions.
3. You may change the ICON by clicking on the drop down arrow next to it.
4. Change the Black Circle with Boarder to White Circle (All White Quarters)

 

[mfexcel]

Ooops... sorry then.
Maybe you need VBA to achieve that, which i could offer little help.

"The drop down arrown next to it" does not seem to be available in MS Excel 2007.

 

[GDunn]

I believe so.
Anyone have a VBA solution please?