HIGHLIGHT DUPLICATES in COLUMN C across 14 worksheets

[Triscia]

I have a spreadsheet that has 14 tabs and I need to find the duplicates in Column C across all of the worksheets. Is there a way to do this in conditional formatting? TIA

[David A Coop]

Here is a formula you can place in the Conditional Formatting for each tab.

Please Login or Register  to view this content.

You will need to copy this formula onto each sheet's Conditional Formatting.

Note: This only works if you have not named the sheets. (ie you have sheets 1 through 14)

If you HAVE named the sheets, then it gets more complicated, and I don't have time to look at it right now - perhaps someone else will assist!

You might like to consider this method I found which sets up a matrix and helps you find where the duplicated are.
https://www.youtube.com/watch?v=L_KJE_pyB34


I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[David A Coop]

Further to #2.

It is easy enough to deal with sheets that have names.

Simply create a list of the Sheet Names somewhere in your workbook, and create a Named Range. In this example, I simply called it MyNames.

Now your formula in Conditional Formatting (on every sheet) becomes:

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".