I am fairly new to Excel, but have searched and looked at the help menu and
cannot figure out how to accomplish what I would like--but know it is
possible as I have another worksheet that does exactly what I want (sort
of).

In cells N 5 to N 9 I have a drop down menu with a Yes or No option. If
they answer NO (only in those particular cells though, as I have other drop
downs and no's are fine) I would like a pre-written message to appear in
merged cells B2 - H2. Otherwise the text would stay hidden.

I know it has to do with conditional formatting, and maybe linked cells?
but I can't seem to quite get it to work.

Any help would be muchly appreciated.

Elissa