Comparing data across dozens of worksheets

Closed
Geist - Mar 19, 2012 at 09:20 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 20, 2012 at 02:39 AM
Hello,

So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to distinguish duplicates. I have tried conditional formatting as well as a few other things but no luck. Is this doable with a new worksheet each week or would something else be better?

Thanks.


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Mar 20, 2012 at 02:39 AM
complete inforamtion not gven
"text in column C to all previous weeks"
should that text be available in ALL THE previous weekly sheet or it is enough if it is available in one or more sheets?
0