Auto populate cells based on dates and other conditions

Hi,

I've attached an excel with three pages.

Page 1 would be a general timing plan, so front product to go into production from a start and end date.

Page 2 would be a facility plan. So Front product would go into a number of cells out of 12.

Page 3 I would like to look at the production dates, match the product up highlight the cells that are in use on that date.

Is that possible?

So for arguments sake. Today if the front product was in production, page 3 will show the cells as in use with a cell fill of green. If there was a clash red, or nothing scheduled empty cell.

I've got some experience of macro programming but not to the extent of you guys, this is a little complex.

Any help appreciated.

Thanks