Highlight duplicates in a filtered Excel defined table

You can highlight duplicates in an excel defined table using conditional formatting. However, that won´t work if you only want […]

Highlight duplicate columns

This article describes how to highlight duplicate records and filter duplicate records. There is one record in each column, cell […]

Highlight duplicate records

This blog post shows you how to easily identify duplicate rows or records in a list. Conditional formatting formula: =COUNTIFS($B$3:$B$15, […]

Highlight duplicates with same date, week or month

Highlight duplicates on the same date Conditional formatting formula: =SUMPRODUCT(--($C3&"-"&$D3=$C3:$C$3&"-"&$D3:$D$3))>1 Highlight duplicates on same week Conditional formatting formula: =SUMPRODUCT(--($B16&"-"&YEAR($C16)&"-"&$D16=$B16:$B$16&"-"&YEAR($C16:$C$16)&"-"&$D16:$D$16))>1 Highlight […]

Highlight more than once taken course in any given day

Question: My scenario is tracking employees who complete online training. I capture their name, id, class taken, and date. Any […]

Highlight duplicate values in two cell ranges combined

Question: How do I highlight duplicate values in two ranges combined? Answer: Range 1, A1:D4, named tbl Range 2, A6:D9, […]

Highlight smallest duplicate number

Question: How do I highlight the smallest duplicate value in a column using conditional formatting? Answer: Conditional formatting formula in […]

Highlight duplicate values in a cell range

Question: How do I highlight duplicate values in a range (A1:D4) using conditional formatting? Answer: Conditional formatting formula: =IF(ROW(G5)>MIN(ROW(tbl)), COUNTIF(OFFSET(tbl, […]

Highlight duplicates in two columns

Question: I need to delete duplicates in two different columns together. How do I highlight the second or more duplicates […]

How to highlight duplicate values

The picture above shows duplicate values in column B, only the second or more duplicates are colored and easily identified. […]