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