Changing colors in a cell does not trigger any sort of trappable event that
could be used to color other cells.

You can use Conditional Formatting to change colors based upon values in
other cells, but that would not help you with your requirements.


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 08:56:18 -0700, laandmc
wrote:

master jan feb
1 yellow
2 yellow yellow

company 1 jan feb company 2 jan feb
1 ** 1 **
2 ** ** 2 ** **


I have a set of tables like this. When I colour the master tables cells in
yellow I want the other corresponding cells with jan and feb in the row to
also turn yellow (**). Is there a way to do this?

Please note that the cells with (**) also have data in them which I need to
keep.