Conditional Formating or Formula?

Hello Excel Guru's ...

I have something this is most likely pretty easy ...

I have a two sheet workbook.

Sheet #1
Column A - Team Manager
Column B - Advisor
At the moment 153 names


Sheet #2
Column A - Team Manager
Column B - Advisor
At the moment 48 names


I want Sheet #1 the Advisor column B ... 153 names
to look at the Advisor column B on sheet 2 ... 48 names
and if the name is on sheet 2 - highlight the matching name on Sheet #1

Is the done with conditional formatting or some sort of formula?

Thanks in advance

What version of Excel are you using?

Have you tried using the MATCH function in your CF formula?

Try this...

Sheet1 B2:B154 = names
Sheet2 B2:B44 = names

On Sheet1...

Select the *entire* range B2:B154 starting from cell B2.
Cell B2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=MATCH(B2,Sheet2!B$2:B$44,0)

Click the Format button
Select the Fill tab
Select the desired color
OK out

You're welcome. Thanks for the feedback!

You might want to contact a mod/admin about the problem updating your profile.