Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I circle the duplicated values entered in Microsoft Excel?

user-image
Question added by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date Posted: 2015/06/08
Ahmed Maher
by Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

go to data tab, select data validation and customize your setting upon your rules the choose circle invalid data from data validation

هاشم المشارقة
by هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

  1. Select cell which you want Excel mark each duplicate values.
  2. Go to Home tap.
  3. From Style Group choose Conditional Formatting.
  4. Select Highlight Cell Rules then Duplicate Values.

Mohammad Basheer abu ahmad
by Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

I'm agree with all answers

More Questions Like This