Identifying new data with certain criteria

[kaiwalls04]

hello! I have a worksheet with several tabs. I want to take the data from one tab and apply it to another . This is a sample of the info from tab 1.

0750010204	Dynamic
0750010205	Dynamic
0750010205

<tbody>
</tbody>

What I want to do is apply the information to the new tab so that if the data from column A on the old tab matches the data in column A, and the word Dynamic is present in column B of the old tab, then the data in column A on the new tab will be bold (or change the font color). Any/all help is appreciated!

 

[BrianMH]

You could do this with conditional formatting. The conditional formatting formula would be something like this.

=vlookup(A2,OldTab!A:B,2,false)="Dynamic"

Set the format in the first cell then copy and pastespecial formatting.