Share via

Conditional formatting for duplicate values returns unique values, too

Anonymous
2022-06-22T13:36:39+00:00

I am trying to review duplicate values for a series of 10-digit numbers. When I use conditional formatting for duplicate values, several unique values are also being highlighted. Why are unique values being highlighted? How can I highlight only duplicates?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-06-29T12:58:13+00:00

Thank you for your replies.

Turns out it was user error.

I was using a filter on my data and some of the highlighted "unique" values had duplicates that were hidden by my filters.

When I copied the filtered returns on another sheet, the highlighted unique values were no longer highlighted.

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-29T06:15:02+00:00

    Hello Ann,

    May I know if you referred to the replies from our community members.

    Feel free to post back to us if you need further assistance.

    Regards,

    Igor

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-06-22T14:17:10+00:00

    Re: "How can I highlight only duplicates?"

    You will have to supply your formula/data to get a CF answer.

    An alternative...

    (no CF used)

    Download the free Professional_Compare workbook from OneDrive...

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    '---
    Nothing Left to Lose

    Was this answer helpful?

    0 comments