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

Quote Originally Posted by JeteMc View Post
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.