I need help with highlighting a duplicate cell in a column.

Kim Betita

I need to highlight duplicate cells in a column. I tried Conditional Formatting but the option is not available.

rrenee

Hi @Kim Betita,

I think you should use a helper/checkbox column that differentiates which rows contain duplicates. Then, use conditional formatting to highlight the desired column cells if the helper column is checked. I tend to use this formula for finding duplicates:

Find Duplicates (HELPER)

= IF(COUNTIFS(ColumnName:ColumnName, ColumnName@row) > 1, 1, 0)

Conditional formatting

IF HELPER is equal to 1 then apply highlight to ColumnName column