Excel Formulas?

[Kirkh435]

Hi,

Looking for some help, I have attached a sample workbook.

This will be for a cost/purchase tracker. the costs go into A,B and C once they are checked in D and E (either by colour or text) I would like the info from C to appear into F.

When F becomes coloured I would then like it to move to G.

I hope this makes some kind of sense. Thanks for you help.

[#2 · Accepted solution]

@Kirkh435 

Coloring a cell doesn't trigger an event, so using text is better.

I added a column to indicate that the amount has been paid.

There is a dropdown in the checked and paid columns.

[#3]

Thanks. That will work nicely. :thumbs_up: