I'm working with a Google Sheet and running into issues with hover text for data validations.

where when the unallowed option is forced through the system:

the custom validation help text is meant to be shown in the message box:

and not as a hover note assigned to the cell with invalid input: