Thread: Need to set up bckgrnd color to link to different worksheets.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Need to set up bckgrnd color to link to different worksheets.
Background colors cannot be linked.

One workaround is to Color the cells on source Sheets via Conditional
Formatting.

Use the same CF on cells in Summary sheet.


Gord Dibben MS Excel MVP


On Tue, 24 Mar 2009 12:06:02 -0700, Yllwroze
wrote:

I have multiple sheets filtering in to a summary sheet. How can I make sure
the background colors of the cells change in the summary sheet when changed
in their sheet?

Reply With QuoteReply With Quote