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