Highlight if same?
Posted by Stephen on January 31, 2002 1:10 PM
Hiya Board
In column a I have a list (2000+) of unique dates from the last 80yrs
Every week I add another 10-15 dates in that column.
How can I ensure that none of the new dates have already been used?
Presently I have to physically check the dates and this is becoming very-very tedious and driving me nuts!!
Any help would be greatly appreciated
Kind Regards
Stephen.
Posted by Adam S. -nt on January 31, 2002 1:48 PM
How about an =if(A2="","",countif(A:A,A2) ) copied in a nearby column?
Posted by Stephen on January 31, 2002 2:15 PM
Re: How about an =if(A2="","",countif(A:A,A2) ) copied in a nearby column?
Adam, - it works ok
I have copied the formula to column B,
Changed the font colour in that column to white, this hides all the Numbers
and then conditional formatted column B with if > 1 highlight the font to red!
Excellent - I have now got some of my life back.
Many thanks
Stephen.
Posted by IML on January 31, 2002 3:58 PM
If you want to avoid a step, just select conditional formatting, change to formula and enter
=COUNTIF($A$1:A1,A1)>1
in cell A1. use the format painter to copy down over your list
good luck
