Matching Data Lists

[clilley113]

Hi,

I have two lists of data over two excel sheets within a workbook. ('sheet 1' & 'Matured')

What I would like to do is input some form of formatting that will highlight any cell on 'sheet one' that contains a value that is on the 'Matured' sheet.

'Sheet 1's data is in cells U2 to U2474

'Matured' data is in cells B2 to B181

Does any one have any suggestions?

Thanks in advance as always!

C

 

[63falcondude]

Re: Matching Data Lists - HELP!

Check out Conditional Formatting. Highlight U2:U2474 of Sheet 1, Conditional Formatting, New Rule, Use a Formula,

=COUNTIF(Matured!B$2:B$181,U2)

Format Fill whatever color you like.

I haven't tested this formula but it should work. Let us know.

 

[clilley113]

Re: Matching Data Lists - HELP!

Amazing that worked perfectly!

One more question...

If i want to highlight any rows that are duplicated, say from row starting A2 - row A2074 how would i do that?

Thanks so much for your help!

C

 

[mesco019]

Re: Matching Data Lists - HELP!

Hello there!

to highlight any duplicated value in the row you can use a conditional rule, first you have to select the range that you would like the rule to be apply, after you go to create a rule, you will see an option that will say "apply format to unique or duplicated values" and then select duplicated values and the color that you will like to have

 

[clilley113]

Re: Matching Data Lists - HELP!

Thanks for the reply.

If i do that it wont only highlight only entire rows that match it will only do it by cell.

Is there a way you an only highlight entire rows that match?

Thanks

C