I have a requirement wherein:
Values in A1 will be entered by users. So if in the adjacent column B1 the status is approved, the entered value stays.
Now the value entered in A2 is rejected in B2, then A2 should become blank (the highlighted one).
<TABLE style="WIDTH: 144pt...