conditional formatting

J

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
 
L

L. Howard Kittle

Select the cells you want to conditional format and use this formula.

=COUNTIF(A2:A102,A2)>1

HTH
Regards,
Howard
 
L

L. Howard Kittle

I believe I missread your post. Not sure my formula will do what you want.

Regards,
Howard
 
Top