Hello Everyone,

I am currently making a table that will be a Shipping log.

I am done with all of the actual formulas now and am trying to make it more visually appealing so when someone looks at the table they will see what is done, in transit and overdue immediately.

For done I have a Conditional Formatting formula that makes the row yellow. My formula for this is =INDIRECT("C"&ROW())="Complete" Complete is the output of a formula that looks for a completion date.(I'm pretty sure that I have terribly designed this as I am new to excel and programming in general)

For In transit I am going to just leave it not highlighted.

Now this is where it gets tricky which is my question.

I have a column for date sent(Column A) and date delivered(Column B)

Date delivered is the column that starts a series of formulas. If there is a date placed in the cell, it changes a cell to complete and moves a tracking number etc etc etc.

So What I want to do is have a formula like the indirect formula but have it look for the conditions Today>7 days after Column A's Date sent AND Column B's cell is ""?

Does any of this make any sense at all? Thank you for your help in advance and let me know if you need more clarification. I'm sure in the future I will make better designs.