Using formulas for dates on invoice tracker

I would really like it to be that it turns red after 30, 60 & 90 days of the date the invoice is due

I can't make sense out of that because once it turns red after 30 days, then 60 and 90 don't matter.

This is a very common type of question but you need to provide very specific information to get an answer specific to your file. The best thing is to attach your file so we can see exactly where all the data is.

To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Here are step-by-step instructions with screen shots

I can't reconcile your original description with the file you attached, but I modified your file in hopes that I got you somewhere close.

I only want the cells that are 30 days and older to appear and the other boxes to remain blank.

I don't understand what you're looking for here--what other boxes?

I would like the whole line to highlight red if it is overdue not just the one column.

I did this.