Bayt.com

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?

Programming Microsoft Excel Data Entry Computer Skills MS Office tools
user-image
Question added by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
Date Posted: 2015/06/08
Upvote (2) Views (4) Followers (1) Answers (3) Report Question
Write an Answer
Register now or log in to answer.
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

Write Your Answer
More Questions Like This