horizontal traffic light slicer

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,056
Office Version
  1. 365
Platform
  1. Windows
i want to make a horizontal traffic light slicer. i have been able to generate a horizontal tile slicer, and i have been able to develop a slicer that displays traffic light icons using conditional formatting. however, the big boss wants a horizontal traffic light slicer at the top of everything. Has anyone been able to do this? or can horizontal tiles be coloured differentl dependent upon their value? and, can the shapes of the square tiles be changed?
 

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.
thanks Matt. I like it. i am having trouble figuring out how to store/capture/sub-in-the-correct-term the images i wish to use. in this instance, the "images" are merely shapes (a green circle, amber triangle, and red square) to give the user the feeling of traffic lights. If it has to be an image, i am sure the net will provide. Currently viewing a tutorial on the subject and the guy grabs images from an online site and copies the Base64 address of each image. Is there another way?
 
Upvote 0
Upvote 0
had not tried any of these. will give them a crack today.
 
Upvote 0
Got it. Found a great tutorial online at
. this explained everything i needed. Cheers.
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,204
Members
453,022
Latest member
RobertV1609

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
Back
Top