Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting on Autoshape
Dear experts,
I've 50 autoshapes of circles numbering from 1 to 50. I want if the value of cell A1 is, for example, 25, then the autoshape of number 25 will be filled with green colour and the font will be changed to bold white colour. This method should be applied to other autoshapes. Can it be done? If yes, please kindly advise how. Thanks in advance. |
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) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
How to use a conditional function to insert an autoshape? | Excel Worksheet Functions |