Add cell reference to Data Validation Messages (Input Message, Error Alert)
Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
This would make possible to use variable contents.
the value here for me is in setting up multiple columns where an input message per column can be pulled from a set of field descriptors without all the copying and pasting currently needed. Comments at the column heading don't work very well
This makes simple sense. It is odd that you can reference cells in the data validation itself but not in the messages.
So, I can say a cell has to have a value between C4 and E4 but when the user enters a value outside the values in those cells all I can say to the user is "You entered a value that is out of range. I'm not going to tell you what that range is (I can't) so just keep guessing. Good luck".
As you can imagine, for the user this is very, very annoying.
I also think this ability would be useful in the hyperlink ScreenTip dialog box too.