Can you use "Conditional Formatting" (limit 3 color patterns in addition to
the present cell color) ... Instead of trying to match Cell Pattern perhaps
you can conditional format based on cell contents. How many conditions do
you need???

Select Format ... Conditional Formatting ... & go from there ...

HTH ... Kha

"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.