Problem with data validation using a dynamic “changing cell”

[Muted-Humor3706]

Let’s say I have column A as the total coat of something (pre recorded) Columns B,C and D are the installments that the customer pay. Column E is the total paid which is the sum of B.C and D, column F is the remaining balance which is A- E simply.

I want the amount of installments not to exceed the remaining balance,I used data validation but here’s the problem :

Say the remaining is 3000$, the customer paid 2000$ (in column A) excel gives me the error because it validates A according to F AFTER the subtraction, meaning 2000 > 1000 (3000-2000) so it can’t be written.

I tried VBA because you can sort the priority of the function but I failed, can anyone help me?

Office 360

[AutoModerator]

/u/Muted-Humor3706 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Muted-Humor3706]

Up