Forum Discussion
Bbartlett25
Feb 20, 2020Copper Contributor
Highlight multiple individual cells in a large workbook linked to a single cell on summary page
I'm working on a large price book database where we have multiple sheets pertaining to various parts of pool building such as excavation, steel, shotcreet, plumbing, etc. I have a summary sheet where I total up the cost of the various components and this cost is comprised of multiple cells on different sheets within my workbook.
Is there a way I can automatically highlight all linked cells with the same color as the summary sheet cell so that when I go back through the sheets I can confirm I've not missed any data? Is conditional formatting an option?
I'm fairly versed in excel and this one has me stumped.
Thanks in advance for any help!
1 Reply
- JKPieterseSilver ContributorYou might benefit from my RefTreeAnalyser utility (free demo): https://jkp-ads.com/reftreeanalyser.asp