Finding duplicates with Conditional Formatting in Excel is easy when the data is on the same worksheet.
When the information is on two worksheets, you have to write a formula and use the CountIF function.
chrismenardtraining.com
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
- Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard ( Download)
- Excel Finding duplicates across sheets ( Download)
- Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting ( Download)
- Compare Two Sheets for Duplicates with Conditional Formatting ( Download)
- How to Find Duplicates in Excel & Highlight Duplicates If You Need To ( Download)
- Three EASY Ways to Find and Remove Duplicates in Excel ( Download)
- How to find duplicates in Google Sheets ( Download)
- Google Sheets - Identify Duplicates between Two Worksheets ( Download)
- Automate Data Transfer from Master to Multiple Sheets in Excel with Power Query – No VBA Needed! ( Download)
- Excel - Find Duplicate Rows Based on Multiple Columns ( Download)
- How to Compare Two Excel Sheets and Find Differences ( Download)
- How To Find Same Values in Different Sheets in Microsoft Excel ( Download)
- Highlight duplicates in lists across worksheets ( Download)
- How to compare two Excel files for duplicates ( Download)
- Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets ( Download)
