Share via

Conditional formatting for duplicate values produce incorrect result

Anonymous
2019-04-03T21:19:51+00:00
  1. Create new Workbook
  2. Select Column
  3. Change Column type to Text
  4. Paste following set:

-8294305351982964027

-8294305351982350909

-8294305351970373107

-8294305351970370122

-8294305351970369758

-8294305351970362434

-8294305351970354068

  1. Select Conditional Formatting -> Highlight Cells Rules -> Duplicate Values -> Ok

Expected: No highlighting (since there are no duplicates in data)

Actual: Rows 3-6 highlighted

Microsoft 365 and Office | Excel | For home | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-04-03T21:55:02+00:00

    Based on my observation Excel just replacing the last four numbers with zeroes.. I would love to report it, but File -> Feeback is not available for me. I think it because I am using my company account and this option is turned off for me.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points
    2019-04-04T08:32:05+00:00

    I will report it, my Excel does have this feature.

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2019-04-03T21:44:17+00:00

    Apparently Excel tries to handle the values as numbers even though the cells have been formatted as Text.

    I'd report this bug using File > Feedback > Send a Frown.

    Was this answer helpful?

    0 comments