This should do it...

=COUNTIF(A2:A102, A1)
--
HTH...

Jim Thomlinson


"jackrobyn1" wrote:

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