Bypassing validation for a column while updating corresponding column

[Neeraj_Malik]

Stuck in typical situation, where I’ve got following columns in a table

1. [Debit Amount] and [Status] columns are editable and the other two columns are having formulas
2. Debit amount has validation where it is valid if [Debit Amount]<=[Balance Left]
3. While adding a row Initial value of column [Status] is set as Pending
4. Status has to be changed to Received through an Action created for updating column [Status]

Now update action is failing for second row as per above table due to validation error [Debit Amount]<=[Balance Left]

Looking for option to bypass the validation during update so that [Status] value can be changed from Pending to Received. Or any other solution to overcome this situation as the given validation is a must requirement

Pls guide.