Hello all, I'm trying to gather my bills in a way that I can monitor paid/unpaid and have a remaining total.
For example:
Account | Total Due| Paid?|
Bill 1 | $101 | YES |
Bill 2 | $100 | NO |
Bill 3 | $100 | NO |
Bill 4 | $101 | YES |
I then want to have another cell showing the remaining unpaid total but I want it to update as I pay bills and change the Paid? column from "NO" to "YES" as well as another cell showing what I've paid out.
For example:
Total Remaining| $200
Total Paid | $202
And the kicker... I want the entire row of an unpaid bill's color to change when the bill is paid. ie unpaid row = yellow paid row = blue
I've tried =IF but can't get that to work properly (perhaps I just don't know what I'm doing wrong) and I can get the colors to work properly but not if I add in a conditional formula. Again Chances are I just don't know enough to understand what I'm doing wrong. I appreciate the help!
Moxy
Bookmarks