G
Guest
Guest
I keep a workbook with two worksheets in it. The first contains a list of all of our, and our competitor's, products, capacities, etc. by location. This information is based on widely published (Annual reports, websites, etc.) data.
The second is nearly a duplicate of the first, but adjustments are made based on any additional (less reliable?) sources (trade conference conversations, newspaper articles, etc.).
Initially, I set the second worksheet to just read the values of the first. Then when I started adding modified entries to the second worksheet, I manually formatted the second page entries to make them standout.
Is there an easy way to use the Conditional Format capability across different worksheets (i.e. if Sheet1!A1 <> Sheet2!A1, format red)?
The second is nearly a duplicate of the first, but adjustments are made based on any additional (less reliable?) sources (trade conference conversations, newspaper articles, etc.).
Initially, I set the second worksheet to just read the values of the first. Then when I started adding modified entries to the second worksheet, I manually formatted the second page entries to make them standout.
Is there an easy way to use the Conditional Format capability across different worksheets (i.e. if Sheet1!A1 <> Sheet2!A1, format red)?