this can be pretty complicated. Its best if someone can
show you this in person. Is there anyone where you work
who can show you how to use conditional formating?


-----Original Message-----
I am wanting to use traffic lights in excel that change
colour based on the
result of a variance cell, ie if the result of the cell
is 10 make the
traffic light green, if it is 20 make the traffic light
amber, if the result
is 30 make the traffic light red. How do I do this?
.