A bug in Excel? Conditional formatting for marking duplicates also highlights unique value

-------------------------------------------------------------------------------
Become or hire the top 3% of the developers on Toptal https://topt.al/25cXVn
-------------------------------------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Quirky Dreamscape Looping

--

Chapters
00:00 Question
02:07 Accepted answer (Score 30)
05:04 Answer 2 (Score 50)
05:25 Answer 3 (Score 14)
06:12 Thank you

--

Full question
https://superuser.com/questions/1411496/...

Question links:
[image]: https://i.stack.imgur.com/r7ing.png
[image]: https://i.stack.imgur.com/TKoXt.png
[iliansky]: https://superuser.com/users/1265842/ilia...
[here]: https://i.stack.imgur.com/zqLNS.png

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#windows #microsoftexcel #office365 #conditionalformatting #duplicate

#avk47