LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
css
 
Posts: n/a
Default highlight duplicate numbers

If I enter a number into any cell which has already been entered into another
cell, regardless of row or column, is there any way in which my attention
could be drawn to the fact that this number is already in the worksheet, i.e.
by highlighting or something similar.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two arrays need highlight duplicate in one of the array Luke Excel Worksheet Functions 4 July 25th 05 08:41 PM
search to identify duplicate enties in long columns of numbers Norman H Excel Discussion (Misc queries) 5 May 19th 05 07:42 PM
prevent duplicate entry for range of numbers 00001 to 99999 in ex. TK Excel Discussion (Misc queries) 4 March 6th 05 03:35 AM
How do you find duplicate values in excel- 2 columns of numbers rickmanz Excel Discussion (Misc queries) 1 December 15th 04 11:16 PM
Add numbers for duplicate entries then delete Chillygoose Excel Worksheet Functions 1 November 2nd 04 04:35 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"