color duplicates

[ttowncorp]

if I have a row of numbers in the C row and another set of numbers in the A row, how do I get it to color if a duplicate number from C matches an A number? like for example make it highlight it with the color yellow.

 

[Marcílio_Lobão]

ttowncorp, Good morning.

Select cells column A as you desire, eg.: A1:A100

Menu Conditional Formatting --> Using formula -->

Type:

[B]=COUNTIF($C$1:$C$100, A1)>0 [/B]

--> Choose desired fill color YELLOW --> OK

Is that what you want?

I hope it helps.

 

[ttowncorp]

this works perfect. thank you.

 

[Marcílio_Lobão]

ttowncorp,

You're welcome.

Glad to have helped you.

Thanks for the feedback.