Hi all.
I have a cell with a data validation drop down in with the options of YES or NO and I want a error/warning message to pop up when YES is selected but no message when NO is selected.
I have no issues with getting the drop down menu via Data Validation and I know the option for an error/warning message is in there too but I want it to pop up when the YES option is selected but I just can't seem to grasp it![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Any advice would be appreciated.
Mark
I have a cell with a data validation drop down in with the options of YES or NO and I want a error/warning message to pop up when YES is selected but no message when NO is selected.
I have no issues with getting the drop down menu via Data Validation and I know the option for an error/warning message is in there too but I want it to pop up when the YES option is selected but I just can't seem to grasp it
Any advice would be appreciated.
Mark