. 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. . A B D H Jump Club 2020 2 yearly dues $700 3 4 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 $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 $495 10 6 carry