if ... then action

T

tony wong

if the left cell is "yes", erase right cell.

How should i do with it in the simplest way?

formula, macro or script?

Thanks.
 
Top