Using Conditional formatting you can highlight duplicates but it doesnt match which cells are duplicates with each other but with this hack you can get there, I show a simple example which works with numbers and another which can work with text too (which requires use of COUNTIFS or COUNTIF function).
Auto-colour in Excel: youtu.be/yO_GHPiAQv4
00:00 - Introduction
00:32 - Highlight duplicates
00:56 - Colour match duplicate numbers
02:02 - COUNTIFS ranks text
04:00 - Colour code text duplicates
06:59 - Colour scales explained
- Colour match each duplicate with Excel's conditional formatting ( Download)
- How To Highlight Duplicates in excel | Conditional Formatting in Excel Color coding | #msexcel ( Download)
- Highlight Duplicates in Excel in Same Column in a Different Colour ( Download)
- Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard ( Download)
- How to Find Duplicates in Excel & Highlight Duplicates If You Need To ( Download)
- Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704. ( Download)
- Compare Two Sheets for Duplicates with Conditional Formatting ( Download)
- How to highlight values that appear in two columns | Compare Two Columns in Excel for Matches ( Download)
- Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting ( Download)
- Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting ( Download)
- Conditional formatting duplicate values color coding; Microsoft Excel Tips and Tricks ( Download)
- Count the number of each duplicate in Excel ( Download)
- Google Sheets - Highlight Duplicate Data in a Column or Row ( Download)
- Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets ( Download)
- Conditional Formatting in Excel Tutorial ( Download)
