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