Excel Formula OR VBA to flag or conditional format Purchase Orders that have gone 90+ days without a payment

[jcornia]

I'm working with a file that has multiple worksheets for different departments that contain Purchase Order information and payments are entered by date moving vertically across the spreadsheet as they are received. I need to be able to easily identify those Purchase Orders that have not received any payment for 90 or more days so that I can close the Purchase Order.

I believe that VBA would probably be the best option given the amount of data already in this file but I'm not sure. If I go with a formula I think that I would want a separate file that would pull the information from the main file, perhaps a Vlookup & Countif??

Any insight will be greatly appreciated.

Thank-you
Jeannie