| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a color based on another color change
I have a sheet which traces progress with colors: green = done, orange =
pending etc. Now I want to report this sheet without the content. I have all the functions to copy and determine colors, but: when I change the color in the source-cell it does not trigger any kind of change! How can I implement that a function is called when the color of a cell changes? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing a color based on another color change
You can't, there is no event associated with a colour change.
You need to monitor the underlying values, whatever causes a cell to be a particular colour. -- __________________________________ HTH Bob "Steve" wrote in message ... I have a sheet which traces progress with colors: green = done, orange = pending etc. Now I want to report this sheet without the content. I have all the functions to copy and determine colors, but: when I change the color in the source-cell it does not trigger any kind of change! How can I implement that a function is called when the color of a cell changes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change color of tab based on color of cell | Excel Programming | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| change cell color based on a tab color | Excel Programming | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Hybrid Mode
