Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Formatting Auto Shapes - Rectangle | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |