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 |
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) |