In cells A2 to A51 the following 3 values are permitted via data validation drop down list
A
B
(Blank Cell)
Requirement:
If value is changed to blank or A in cells A2 toA51, then the corresponding column AG must be cleared.
Example: A25 changed to blank, then AG25 contents must be cleared.
Solved by M. U. in 26 mins