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.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]0750010204
[/TD]
[TD]Dynamic
[/TD]
[/TR]
[TR]
[TD]0750010205
[/TD]
[TD]Dynamic
[/TD]
[/TR]
[TR]
[TD]0750010205
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.