. Total paid column (formula/function - use structured refs) Left to pay column (formula/function - use structured refs) Paid in full column (use an IF function, structured refs, and the appropriate message) Add Conditional formatting to the Total Paid column -- as the example. . D Jump Club 2020 2 yearly dues $700 3 name dues paid 1 dues paid 2 dues paid 3 dues paid 4 total paid left to pay paid in full? 5 bob $60 $45 $100 $150 $355 6 carry $175 $160 $175 $190 $700 7 ish $50 $175 $120 $110 $455 8 steve $140 $140 $140 $280 $700 9 Joe $20 $175 $200 $100 10 $495