What is conditionally formatted hyperlink?

How will Excel know if an incorrect selection has been made from the
dropdown?


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 21:04:01 -0700, Michele
wrote:

Hi,

I am creating a workbook, where I have several worksheet that are labeled
with the same first 7 characters "ab123 -".

The user selects one of these sheets from a dropdown in the first worksheet.
I provide a conditionally formatted hyperlink within worksheet A, based on
their selection, but for quality control want an additional step that either
locks an incorrect selection or presenting a msgbox to re-direct.

Can this be done?

Thanks
Michele