find, bold & sort duplicates in 2 spreadsheets

[edzzz]

i have 2 spreadsheets listing, among other data, SS#s. i'm trying to create a new list of SS numbers that are found in BOTH spreadsheets. is there a way to do this that would also bold or highlight the numbers found in both sheets? and, if so, is there a way to sort by bold or highlighted lines to easily create a separate list?
thanks a lot,
eddie

 

[edzzz]

on another site i found how to filter duplicates to either hide or remove them, but i need to do the exact opposite - i *only* want to see the duplicates. please tell me there is a way to do this other than combining the 2 sheets, sorting by SS and manually higlighting/bolding dups. both sheets are thousands of lines long. waaahhh.

 

[Jim North]

Hello edzzz,

You can wipe the tears away.... there is a way... and it's probably the same way you saw on the other site... conditional formatting? It's just a matter of changing the formula you test with.

Conditional formatting looks for a true/false condition. The following:

=COUNTIF(B10:B14,A10)>0

...says count the number of times the value in A10 is found in B10 through B14... and if it's greater than 0 it is TRUE.