I know I can accomplish this using conditional formatting; however, there is/will be a lot of data so I wanted a VBA to do this.
What I am wanting to do is have the "PO# Due Date" in Column Q highlight red if it is past Today and Column W ("Received Date") is blank, and/or Column W is passed...