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?