G Guest Dec 23, 2004 #1 How do I get traffic lights in excel that change colour depending on the result returned in a variance cell?
How do I get traffic lights in excel that change colour depending on the result returned in a variance cell?
D Debra Dalgleish Dec 23, 2004 #2 You can use conditional formatting to change the colour of a cell. There are instructions in Excel's help, and here: 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
You can use conditional formatting to change the colour of a cell. There are instructions in Excel's help, and here: 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
G Gord Dibben Dec 23, 2004 #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
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
