Hello!

I need help setting up a spreadsheet to track our accounts receivable. The setup pretty much looks like this:

A B C D E F G H

Invoice #, Invoice Date, Invoice amount, 0-30 days, 31-60 days, 61-90 days, 91 - 120 days, and then 121 + days

Is there a way/formula that can automatically input the invoice amount into the appropriate column (either 0-30, 31-60, 61-90, etc.) and also make it bold and red if it's in a column that exceeds 60 days?

Your help will be much appreciated!!!!