As far as I know, Excel does not recognize a color change as an event to
which it will react. The same for Conditional Formatting. Perhaps you can
work with the condition that drives you to color either of those 2 cells.
Post back and provide more info on what you have and what you want to have.
HTH Otto
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.