Hi im new so go easy.
Ok so im building a workbook and i have a sheet that records sales/invoices. I insert date using a pop-up calendar, the payment terms in days is determined via VLOOKUP depending on which customer is selected from drop down, fine no problem. My payment due date cell simply adds the date ive inserted to the payment terms day cell and returns a due date eg 04-sep +10 days returns 14-sep to that cell, simple enough. This cell however i have conditionally formatted to display red if this cell is less than =TODAY(). again fine no problem. this shows an easy to see customer whos payment is overdue. a few columns along i have a Payment status column with a drop down with "Paid" & "Unpaid". I want to be able to overide the previously mentioned conditional formatting once that transaction has been marked "Paid" and this is where im stuck?
Any ideas would be greatly appreciated.
Thanks
Ross
Bookmarks