Conditional Formatting Cells/Shapes
 

Hi Each and All,

This is what i'm trying to achive,
I'm trying to create a kind of traffic light type of status indicator,
If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill Amber &
if cell AI70 then fill cell A3 green, I've achived this through conditional
formatting, But it would be even better if the cells A1-A3 were round in
shape, any ideas?

Repects

Conditional Formatting Cells/Shapes
 

See http://xldynamic.com/source/xld.CF.html#lights

or if you don't want CF, take a look at the chart wizard's site (Andy Pope),
http://www.andypope.info/charts/trafficlight.htm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LaDdIe" wrote in message
...
Hi Each and All,

This is what i'm trying to achive,
I'm trying to create a kind of traffic light type of status indicator,
If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill Amber
&
if cell AI70 then fill cell A3 green, I've achived this through
conditional
formatting, But it would be even better if the cells A1-A3 were round in
shape, any ideas?

Repects

Conditional Formatting Cells/Shapes
 

Thank very much Bob, Works fine now, just how I wanted it!

Seeya

"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.CF.html#lights

or if you don't want CF, take a look at the chart wizard's site (Andy Pope),
http://www.andypope.info/charts/trafficlight.htm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LaDdIe" wrote in message
...
Hi Each and All,

This is what i'm trying to achive,
I'm trying to create a kind of traffic light type of status indicator,
If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill Amber
&
if cell AI70 then fill cell A3 green, I've achived this through
conditional
formatting, But it would be even better if the cells A1-A3 were round in
shape, any ideas?

Repects

Conditional Formatting Cells/Shapes
 

Seeya,

For my information, which did you use?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LaDdIe" wrote in message
...
Thank very much Bob, Works fine now, just how I wanted it!

Seeya

"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.CF.html#lights

or if you don't want CF, take a look at the chart wizard's site (Andy
Pope),
http://www.andypope.info/charts/trafficlight.htm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"LaDdIe" wrote in message
...
Hi Each and All,

This is what i'm trying to achive,
I'm trying to create a kind of traffic light type of status indicator,
If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill
Amber
&
if cell AI70 then fill cell A3 green, I've achived this through
conditional
formatting, But it would be even better if the cells A1-A3 were round
in
shape, any ideas?

Repects

Conditional Formatting Cells/Shapes
 

http://xldynamic.com/source/xld.CF.html#lights

Thanks again Bob.

"Bob Phillips" wrote:

Seeya,

For my information, which did you use?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LaDdIe" wrote in message
...
Thank very much Bob, Works fine now, just how I wanted it!

Seeya

"Bob Phillips" wrote:

See http://xldynamic.com/source/xld.CF.html#lights

or if you don't want CF, take a look at the chart wizard's site (Andy
Pope),
http://www.andypope.info/charts/trafficlight.htm

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"LaDdIe" wrote in message
...
Hi Each and All,

This is what i'm trying to achive,
I'm trying to create a kind of traffic light type of status indicator,
If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill
Amber
&
if cell AI70 then fill cell A3 green, I've achived this through
conditional
formatting, But it would be even better if the cells A1-A3 were round
in
shape, any ideas?

Repects