Conditional Formatting To Highlight Unique Values
How to use and apply the Conditional Formatting rules by using custom options please follow the step shown below and example in image and video.
NOTE:- Conditional Formatting Rules Always Work On The Base Of True & False Only.
Select The Range Of Your Data.
GO To Home Tab
Then Go To Conditional Formatting.
Then Click & Select New Rule.
One Dialog Box Will Get Pop-Up
Then Select Format Unique Or Duplicate In Second Last In Option List.
Once Its Done Select The Formatting Option According To Your Requirement As Shown In This Example.
Once It's Done Click Ok.
Then Use Filter With Color And You Wil Have All Unique Numbers.
That's It :)