View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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?