View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laandmc laandmc is offline
external usenet poster
 
Posts: 23
Default changing table cells colours using a master table

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.