conditional formatting
 

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

conditional formatting
 

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

conditional formatting
 

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

=COUNTIF(A2:A102,A2)1

HTH
Regards,
Howard

"jackrobyn1" wrote in message
...
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

conditional formatting
 

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

Regards,
Howard

"L. Howard Kittle" wrote in message
. ..
Select the cells you want to conditional format and use this formula.

=COUNTIF(A2:A102,A2)1

HTH
Regards,
Howard

"jackrobyn1" wrote in message
...
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

conditional formatting
 

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

"L. Howard Kittle" wrote:

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

Regards,
Howard

"L. Howard Kittle" wrote in message
. ..
Select the cells you want to conditional format and use this formula.

=COUNTIF(A2:A102,A2)1

HTH
Regards,
Howard

"jackrobyn1" wrote in message
...
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