Hi Guys,
I'm trying figure out how to conditionally format the data in one table based on the criteria specified in another table on a different worksheet.
The Table I'm trying to format has a series of Products and Volumes that'll be available on different dates.
Table 1.jpg
The Criteria table has each product and a corresponding Key Data.
Table 2.jpg
All I want to be able to do is have the cell corresponding to the criteria to be highlighted but can't for the life of me figure out how to do it.
If it makes a difference I'm working offAttachment 338501 a Mac. Excel Version 2011 14.4.3
Appreciate any help
Bookmarks