Lookup and Bold Values

[Mir@nda]

I would like to be able to lookup values in one table and
if there is a match in the second table, have the matching
values become bold or change to red. Any help on this
would be greatly appreciated.

Regards,

Mir@nda

 

[Don Guillett]

Have a look in the visual basic editor HELP index for FIND. A good example
is there.

 

[Dave Peterson]

Maybe format|conditional formatting would work for you:

Select your range
then Format|Conditional formatting
Formula is:
=isnumber(match(a1,sheet2!$b$1:$b$1000,0))
Where A1 is the activecell in the selected range
and sheet2!b1:b1000 is your second range.

Don't forget to give it that bold/red format.