| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making "traffic lights"
Hi,
I have a column where are values 3,2,1 and I want to make a "traffic light" indivator out of them. 3 is green, 2 is yellow and 1 is red. If the cell is blank, it means yellow. I made 3 ovals on the sheet. The logical solution would be: (if 3 then green, (if 1 then red,), else yellow) But I can't code it. The light indicator should be next to the cell that has the value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting using Traffic Lights | Excel Discussion (Misc queries) | |||
| How to create "stop lights" as drop down box options? | Excel Discussion (Misc queries) | |||
| Conditional format - 3 traffic lights | Excel Worksheet Functions | |||
| How do I use traffic lights in excel | Excel Discussion (Misc queries) | |||
| Making "examp le" become "examp_le" in a string | Excel Programming | |||
Threaded Mode
