Hi All,

I haven't used Excel for a few years and I've been asked to create a Cost
Records Spreadsheet. I've got all my column headings and totals along the
top.

The last 3 rows at bottom, I've named them as "Paid For", "To Be Paid" and
"Totals" for adding up each column. Is there a way when I enter an amount
into a cell, it tells the the bottom rows if it's a paid for or to be paid?

Please keep is simple.

Regards :)