Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of an autoshape
I am using Excel 2003 for my project and I have to set color of an autoshape
in column C based on the value in column B. For example: *If the value in column B < 80%, a little square in column C must be Red *If the value in column B is from 80% to 89%, a little square in column C must be Yellow. *If the value in column B 90%, a little square in C must be Green. I've tried Conditional format, but it didn't work. Can someone help me please. Any help is appreciate. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill autoshape color with ref cell conditional formatting | Excel Worksheet Functions | |||
autoshape color conditional formating | Excel Discussion (Misc queries) | |||
Change color of Autoshape in chart | Excel Programming | |||
How do I change the color Excel Autoshape using VBA? | Excel Programming | |||
Change AutoShape Text Color in VBA? | Excel Programming |