Data Validation Custom Formula, Restricting Entry

[aqeel.bukhari]

Hi...!
Can anyone guide me adding Data Validation custom formula in to "FILLED QTY GALLON" column to restrict entry if entered quantity is more than the balance quantity in Column O for that particular Tank Number.

[Estevaoba]

Welcome to the forum.

Try this formula in the data validation:

Please Login or Register  to view this content.

Good luck!

[aqeel.bukhari]

This worked perfect....! Big thanks for the quick solution.

[Estevaoba]

You’re welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day.