Invoice highlighting due dates conditional formatting

**toneNFFC** · 06-24-2015, 04:36 PM

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

**Shareez Saleem** · 06-24-2015, 04:59 PM

Assume that invoice date is column C, try this formula =(TODAY()-$C2)>=30

Attached file FYR.

Regards
Shareez

**toneNFFC** · 06-24-2015, 05:06 PM

Originally Posted by Shareez Saleem

Assume that invoice date is column C, try this formula =(TODAY()-$C2)>=30

Attached file FYR.

Regards
Shareez

Brilliant!!! Thanks for your help Shareez. Works like a dream

**Shareez Saleem** · 06-24-2015, 08:02 PM

Thank you.

Please close this Thread as "Solved" using thread tools above this page and add also you can add "Reputation" if you are fully satisfied with our answer.

Regards
Shareez