Comparing data across dozens of worksheets

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
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?