G
Guest
Im looking for help with the following spreadsheet im trying to create
1) Im creating a spreadsheet for our plating department with 6 fields (Date sent, Purchase Order Number, Invoices within Purchase Order, Finish Code (color of plating), Plating Company Sent To, and Recieved Date).
For example
A B C D E
Date Sent PO # Invoices Finish Company Date Recieve
I want to use conditional formatting to have a row highlighted if these two cases are true -- the Date Sent is equal to or less than 14 days from todays date (has been at plating for 14 days or more) and the Date Recieved field must be blank for that particular row (we haven't recieved it back yet).
(Ideally, id like to be able to use yellow highlight for 2-4 weeks out and not recieved, and red for 4-6 weeks out and not recieved
And separately from the conditional formatting..
I also want to be able to have a list of each invoice in each purchase order (every purchase order contains many customer invoices) AND be be able use the 'List' feature so that I can list by Invoice number also
Thank you for any hel
1) Im creating a spreadsheet for our plating department with 6 fields (Date sent, Purchase Order Number, Invoices within Purchase Order, Finish Code (color of plating), Plating Company Sent To, and Recieved Date).
For example
A B C D E
Date Sent PO # Invoices Finish Company Date Recieve
I want to use conditional formatting to have a row highlighted if these two cases are true -- the Date Sent is equal to or less than 14 days from todays date (has been at plating for 14 days or more) and the Date Recieved field must be blank for that particular row (we haven't recieved it back yet).
(Ideally, id like to be able to use yellow highlight for 2-4 weeks out and not recieved, and red for 4-6 weeks out and not recieved
And separately from the conditional formatting..
I also want to be able to have a list of each invoice in each purchase order (every purchase order contains many customer invoices) AND be be able use the 'List' feature so that I can list by Invoice number also
Thank you for any hel