| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of Shape based on condition - Macro?
I need to have an auto shape, just a regular rectangle, change color based on
a cell next to it. The cell next to it contains an IF statement to either put a 1 or a 0 depending on another sheet. I would like the button color to be grey 25% if the if statement result is 0 and light green if the if statement result is 1. Does anyone know how this could work? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change line chart color based on condition like + and -. | Charts and Charting in Excel | |||
| how to change a cell color based on its content using macro? | New Users to Excel | |||
| Change row color based on condition of celss | Excel Worksheet Functions | |||
| change shape by condition | Excel Discussion (Misc queries) | |||
| Color Change in chart based of condition | Charts and Charting in Excel | |||
Threaded Mode
