by Sisyphus » Fri Dec 09, 2011 3:15 am
Hi,
You may like to consider Conditional Formatting. Set the Formula to something like this:
- Code: Select all
=($A$1:$A$2000=$A1)
I need to try this to be sure of the formula (can't do that on this iPad) but the basic idea is that the current cell (A1 in the example) is compared with all the other cells in the range. The formula will return True if a duplicate is found and that cause the cell to be highlighted, for example. The matching cell isn't affected by this action, but if it is similarly formatted it will also be marked in the same way.
Have a pleasant day!
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)