Posted to microsoft.public.excel.worksheet.functions
|
|
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
|