If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter jcornia
Start date Nov 29, 2018
Tags

countif 2 conditions met file purchase order vba & excel 2016 vlookup

jcornia

New Member

Nov 29, 2018

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