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

Absolutely perfect this, going to look into how it’s done so I can understand and evolve it. Thanks very much

Originally Posted by JeteMc

This proposal adds two columns (P:Q) on the Products Sheet.
Columns P:Q show the start and end dates for the product and are populated using: =IF($B5="","",INDEX(Timing!H$8:H$167,MATCH($B5,Timing!$B$8:$B$167,0)))
On the Flex Cell Capacity sheet B6:M34 are populated using: =COUNTIFS(Products!C$5:C$6,"x",Products!$P$5:$P$6,"<="&$A6,Products!$Q$5:$Q$6,">="&$A6)
Note that B6:M34 are custom formatted ;;; to hide the results of the formula.
The conditional formatting rules are:
For green: =B6=1
For Red =B6>1
Let us know if you have any questions.