traffic light function?

**Kees Korver** · 01-10-2010, 08:10 AM

Hello all. An intriguing question, I never found an answer anywhere ....
I want to include a simple dashboard-light, which turns green, yellow or red, dependent on a value, eg in A1. [like the one appearing after my name]
A1<100 => light turns green
A1 100-500 => light turns yellow
A1 >500 => light turns red
Does something like this exist? Preferably in VBA code?
Appreciate any solution!
Thanks, Kees

**royUK** · 01-10-2010, 08:19 AM

Is this what you mean?

http://excel-it.com/excel_conditional_formatting.htm

**teylyn** · 01-10-2010, 08:28 AM

Kees, it would really help if you updated your profile with the Excel version you're using, especially since Excel 2007 and later has built-in traffic light functionality that is quite different from Excel 2003.

cheers

**Kees Korver** · 01-10-2010, 10:29 AM

Originally Posted by teylyn

Kees, it would really help if you updated your profile with the Excel version you're using, especially since Excel 2007 and later has built-in traffic light functionality that is quite different from Excel 2003.

cheers

Teylin, of course you're right; just updated my profile (by the way I use Excel 2003, SP3)

**Kees Korver** · 01-10-2010, 10:31 AM

Originally Posted by royUK

Is this what you mean?

http://excel-it.com/excel_conditional_formatting.htm

Thank you, RoyUK.
But unfortunately > this is the simple Conditional Formatting of a cell.
I would be very pleased to include a separate "lightbulb" somewhere on my Excelsheet, which turns green/yellow/red when a certain condition is met. Something like a separate illustration which changes dependent on this condition. Hope this is possible some way ...

**teylyn** · 01-10-2010, 03:20 PM

Kees, have a look at this:

http://www.exceluser.com/solutions/traffic.htm

Although Charles Kyd uses a whole graph with a traffic light background, the same principle can be applied to other images ....

**Andy Pope** · 01-11-2010, 05:47 AM

Something like this perhaps
http://www.xldynamic.com/source/xld.CF.html#lights2

**Kees Korver** · 01-11-2010, 01:18 PM

Originally Posted by Andy Pope

Something like this perhaps
http://www.xldynamic.com/source/xld.CF.html#lights2

Thank you Andy! Was exactly what I am looking for. Didn't know that even these nice things are possible in Excel. Feel inspired ....

**Kees Korver** · 01-11-2010, 01:25 PM

Originally Posted by teylyn

Kees, have a look at this:

http://www.exceluser.com/solutions/traffic.htm

Although Charles Kyd uses a whole graph with a traffic light background, the same principle can be applied to other images ....

Thank you Teylen for all your efforts. I learned a lot. What I actually was looking for is described in the reply of Andy > "real" traffic lights which can be switched to red-yellow-green. Very nice!