hi guys,
i want to know how to prevent selecting same cell when using data validation list, because i used data validation for a large number so i want to choose every cell just one timee, in the attached sheet in i'll use data validation for entire column H, and i want to select every cell only once, thanks in advance .
Hi amr,
I'd use Conditional Formatting. If you put a duplicate in col H it will turn RED. See the attached:
Also look at: http://office.microsoft.com/en-us/ex...001136616.aspx
for earlier version of Excel. Excel 2010 has a "duplicates" selection in the CF dropdown.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
@ MarvinP
what a greet idea, thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks