Hi everyone.

I was wondering if it would be possible to make different comments to
appear in the same cell depending on a selection from a validation
drop-down menu.

Let me expand a little bit on this:

Cells A1, A2, A3 have values of 1, 2, 3

Cell B1 is where the validation menu would appear (choices 1, 2 and
3), and the cell which would have a comment

Cells C1, C2, C3 have values of "one", "two", "three"

Would it be possible for me to create a comment in B1 which would
change based on a selection in that same cell?
(so that when I select a number, comment changes to the corresponding
word)


thank you