On Sun, 18 Oct 2009 01:50:01 -0700, JBeaucaire
wrote:

You can actually put the word SPORT into the cells before applying the Data
Validation for the drop-down list. When they click the cell, SPORT will be
the current value, but it will not be a value IN the list.


You can comment the dropdown list so that hovering over the cell pops
up the note.

You can also comment the cell itself.

One pops up the comment when the cell is selected, the other, when
hovered over. You want the hover version as cell selection puts up the
drop down list.