Evening All,

I have a spreadsheet that I track client/company invoices on and I'm looking for the whole row to highlight in red when the date is over 30 days old from the day the invoice was sent. The sheet has 16 columns for numourous data and the invoice sent is column A.

I have looked on numourous forums and sites and have tried implementing people theory but cannot get the conditional formatting to work the way I would like.

Any help would be greatly appreciated

Tone