I want to restrict a value in a cell based on another cell in the same row.
The value in A must not exceed what is in B. If the value in B is zero, any figure is allowed in A
A | B --- 4 | 9 – allowed 5 | 0 – allowed 6 | 5 – the value in A should not be allowed
How to set up data validation for this in column A.
I want all rows in Column A to have this validation rule.