Formula question to grey out a cell and not count it

[Desperados77]

Okay, so question i have is this, i have a budget sheet that has the monthly bills in their own cell and my net on top and the leftover on the bottom. so basically the leftover formula is the sum of the positive currency minus the bills.

so what i am trying to do is once the payment is taken out by the bank i want to update the spreadsheet by either graying out the bill amount so its no longer valid since its paid, but i want to see still how much i paid. basically i want the leftover formula not to count that value. Because i then update the net part with what is in the bank.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...regards-formulas-post5343667.html#post5343667

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).