changing a color based on another color change

[Steve]

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?

 

[Bob Phillips]

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.