Traffic lighting

[Guest]

Is there a way of displaying "traffic lights", the colour of which is driven by data in a cell. eg if sales are over target the light shows green, within 10% of target, the light shows amber, more than 10% below target the light shows red

Any thoughts gratefully received!

 

[Jim]

Format>Conditional Formatting

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

Is there a way of displaying "traffic lights", the colour of which is

driven by data in a cell. eg if sales are over target the light shows green,
within 10% of target, the light shows amber, more than 10% below target the
light shows red?

 

[Guest]

think I've just answered my own question by reading other postings - conditional formatting's the answer!

 

[Peo Sjoblom]

You can use conditional formatting for that,

if the cell you want to change colour in is A1 and the target is 100,
do format>conditional formatting, formula is

=A1>100

click the format button and patterns and select green,
click OK, click the Add button formula is and use

=AND(A1>=100*90%,A1<=100)

format patterns and select amber (or what looks closest)
click OK, select add and for the 3 condition use

=AND(A1<100*90%,ISNUMBER(A1))

format>patterns and red

If you want this done in another cell add dollars signs like this

=AND($A$1>=100*90%,$A$1<=100)

to make the reference absolute



--

Regards,

Peo Sjoblom

Is there a way of displaying "traffic lights", the colour of which is

driven by data in a cell. eg if sales are over target the light shows green,
within 10% of target, the light shows amber, more than 10% below target the
light shows red?

 

[Nikos Yannacopoulos]

From the main menu, Format > Conditional Formatting.

Nikos

-----Original Message-----
Is there a way of displaying "traffic lights", the colour

of which is driven by data in a cell. eg if sales are over
target the light shows green, within 10% of target, the
light shows amber, more than 10% below target the light
shows red?