This is really something that is much easier to accomplish via sql. I would recommend importing into access and building queries to get min and max sizes + all available colors. I would also decouple the available sizes/colors with missing sizes/colors and output all missing items/colors as a seperate report.

You are missing some data to accomplish this... You need a lookup on which products should use which size lists. As well as which products should have available which colors. I hope this points you in the correct direction, but it is a significant amount of work to get all of this set up and excel just isnt build to handle the many-to-many relationships that are necessary to do this properly.