Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

 3 Answer(s)

  • You will need to use Conditional formatting for this. For example if you want to highlight duplicate values in Column B , right-click on the Column B and select 'Conditional Formatting' , specify the range say 'B1: B15' under 'Apply to range'. Under the field 'Format cells if' select the option 'Custom formula is' and enter the following formula : =countif($B$1:$B$15,B1)>1

    In the 'Formatting style ' option select a color to highlight the duplicate cells. You will now see the duplicate cells highlighted by this color.

Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: