Highlight duplication

Hi Ieza

Thanks for getting in touch. You can do this via Conditional Formatting.

Select your range, then on the Home tab go to Conditional Formatting > Highlight Cells Rules > Duplicate Values. From here you can choose your formatting style.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector