Hide rows meeting multiple criteria and search for unique values

Hello,

While hours reading posts and forums have increased my knowledge of VBA in which I can create parts of the following request I am still unable to achieve all of the following in one vba code that would update when the document is opened, any help would be greatly appreciated.

Users assign products to set shelving areas by entering product codes in cells C6:C32 or J6:J32 and the following few coloumns are populated with the product name and stock levels that are populated using vlookup. These products are selected from a linked Master List of products listed in rows C35:1035. The VBA I am trying to accomplish is to shorten the master list by automatically hiding rows in the linked master list from c35:c1035 where coloumn A is "Discontinued" and coloumn J is less than or equal to 0. The additional measure that I was hoping to achieve is to change the row fill colour to red for any items in rows c35:c1035 where coloumn J is greater than 0 and the product code in coloumn B is not already in C6:C32 or J6:J32.

I have spent more hours on this than I care to admit and as mentioned any help is appreciated.