Question Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a spreadsheet with multiple worksheets. I want to run conditional formatting/highlight cell rules/duplicate values to mark duplicate data (item numbers). The worksheets are labeled by month and there are 12 of them. For instance, if on sheet 1 (january) in cell B617 the number is 23466778 I want to see if there is the same number on any of the worksheets. I use ctrl f, then find all, and so far it will only check the active worksheet.
3 replies
by colesbraxton Accepted solution
Clarifications
by thumbsup2 Accepted solution
CTRL+F and then click Options to switch to search WORKBOOK instead of SHEET. To do anything else, you'll need to write a macro to do it for you.
But, what has that got to do with LINK worksheets? Links are for calculated values based on values taken from other workbooks. If everything you want to look at is in the same workbook, you don't need links.
by colesbraxton Accepted solution
You are correct, I just didn't know how to title my request. I followed your suggestion and it worked like a charm.
thank you
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies