Need to set up bckgrnd color to link to different worksheets.

  • Thread starter Thread starter Yllwroze
  • Start date Start date
Y

Yllwroze

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?
 
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
 

Ask a Question

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.

Ask a Question

Similar Threads

Could this be accomplished with an if, then statement 2
Spreadsheet summary automatically referrences totals of worksheets 2
Adding data from multiple cell and linking to a new worksheet 3
Linking to other worksheets 3
Accessing Other Sheet Tabs from within Excel 2
Linked cells - why '0' when blank? 3
Summary 2
summary values across worksheets within the same workbook 2

Back
Top