I am looking for help for making a cell mandatory based on an answer in another cell.
Requirement : I have a list in column A ( Change Rule, Delete Rule, New Rule) starting from A3 and so on.
If column A3 : A10 has the word “Change Rule“ or "Delete Rule" in the cell then I would like to mandate Column S. We can not leave the cell (column S) blank. I want a message pop up to be come when a person select any one of them (“Change Rule“ or "Delete Rule") in column A3 or A4 or so on and forgot to fill details in column S3 or S4 etc.
Nothing happens when person select "New Rule".
Please provide me an appropriate VBA coding for the same....