Lookup and Bold Values

  • Thread starter Thread starter Mir@nda
  • Start date Start date
M

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
 
Have a look in the visual basic editor HELP index for FIND. A good example
is there.
 
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.
 
Back
Top