Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get traffic lights in excel that change colour
How do I get traffic lights in excel that change colour depending on the
result returned in a variance cell? |
#2
|
|||
|
|||
You can use conditional formatting to change the colour of a cell. There
are instructions in Excel's help, and he http://www.contextures.com/xlCondFormat01.html Or you could create a traffic light chart. Andy Pope has instructions on his web site: http://www.andypope.info/charts/trafficlight.htm Shorty wrote: How do I get traffic lights in excel that change colour depending on the result returned in a variance cell? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
See answer to your other post in excel.misc NG
No need to multi-post. All the regulars monitor all the Excel groups. If you MUST post to more than one group, please cross-post so's the cross-post will be marked. Gord Dibben Excel MVP On Wed, 22 Dec 2004 16:23:02 -0800, Shorty wrote: How do I get traffic lights in excel that change colour depending on the result returned in a variance cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How do I use traffic lights in excel | Excel Discussion (Misc queries) | |||
Macro button colour change??? | Excel Worksheet Functions |