conditional formatting

[jackrobyn1]

i understand basic conditional formatting but if i have a number in cell A1
and a series of numbers in a column from A2:A102 what formula can i use to
colour cell A1 if there is the same number anywhere in the colum A2:A102. ??

In other words a formula that looks for a match for whatever the number
happens to be in A1
Thanks

 

[Jim Thomlinson]

This should do it...

=COUNTIF(A2:A102, A1)

 

[jackrobyn1]

thanks the first formula works a treat, exactly what i wanted. cheers