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?

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" <(E-Mail Removed)> wrote in message
news:134D92B2-F07D-40C1-9364-(E-Mail Removed)...
>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?