traffic lights

  1. D

    Dashboard with Lights

    Hello, I'm trying to create a professional looking Dashboard that a person can look at and know if everything on the document has been filled out. I was thinking of using the stoplight feature, but I cannot figure out how to make it look for words instead. An example would be that on sheet 1...
  2. V

    IF cell Contains "text" then lookup "Colour"

    Hi all, I need to format a column/set of cells where each cell has some text in it, and depending on a defined list elsewhere that text does a contains lookup to see whether to colour that cell in Green/Amber or Red. I was going to use the conditional formatting traffic lights but I dont know...
  3. M

    Traffic Light formatting with labels

    I've seen several threads on conditional formatting using traffic lights, but haven't seen how to include row labels with the traffic lights. Here is a snapshot of what I'm trying to accomplish. The formula in the R, Y, G is IF(X29>=0.00000000001,1,IF(F3<0,F3/-C3,IFERROR(F3/C3,-500))) and my...
  4. G

    Icon Set Traffic Light Colours

    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

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