Conditional Format

Hey Guys,
Here is the question!

How to Apply Conditional format for particular Column?
Col Name: RRN
Conditional Format: Colour “LightRED” for all duplicate values

Suggestions Please

Regards,
Nidhi

Hello @nidhi.kowalli ,

You can apply a VBA macro on your excel file.

Here’s the VBA code that you should invoke:

DuplicatesColors.txt (393 Bytes)

Any other method Excluding VBA?

Not aware of any for the moment. But getting used to VBA can be very useful in many situations.