Macro Help
 

Hi,

I am trying to do the same thing with my drop down list. I get my macro
to run using the shortcut key, but when I select a item from my drop
down, it does not take me to another worksheet within my book. The
code is exactly the same, can you help me with this problem.

Adrianne

Macro Help
 

Hi Adrianne,

In my opinion, there is no need for a macro ...
With conditional formatting, use Formula Is
=ISNA(Match(yourCell,yourRangeName,0))
and pick whatever format differentiator you want ...

HTH
Cheers
Carim