horizontal traffic light slicer

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,014
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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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,216,123
Messages
6,128,975
Members
449,480
Latest member
yesitisasport

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