Dear Excel Experts,
I have an issue. I am trying to make a formula which must mark in red the name of the company in RED if it is with overdue invoices. I am sending you simple table.
The formula must check the date (today) and after that search for the name of company and after that to check the payment delay and if it is overdue it must mark in red the name of the company. I think that this is the way, but I am not a expert and may be is not the right way.
I will appreciate your help!
Thank is advance.
EXCEL.jpg
Bookmarks