I'm tracking incoming shipments from different companies and I would like to have the sheet highlight the company name when I have received all the shipments from that company, like in the attached example. Is there a way to do this with conditional formatting?

https://docs.google.com/drawings/d/1...wzpZoiaHw/edit