Hi All,
I have created a data validation rule and inserted that to a form. Validation condition is if the respective cell amount is more than 100000 highlight in pink color. The validation is working accurately. My requirement is to mandate a comment on such figures which should be entered by the data entry user (to give reasons for the exceed).
I referred so many documents but all of those are mentioning about entering a comment but not the mandating part. Can anyone help me to setup this functionality.
Regards,
Thulya