VBA forConditional Formatting for range where criteria is on top of range

[kedarlimaye87]

I Am having difficulty in applying conditional formatting via VBA for my file (See Attached). Basically this is extract of large report file which i work on. in attached file in column A there are 6 types mentioned those are basicaly products and in row 12 there are headers for 9 different returns which system calculate. i have periodic threshold for each type of product for every return type which i have populated in Blue cells above each type of product. i want to do conditional formatting for each product range like Type 1 product having data range in attached file is C15:K25 to get conditionally format with criteria written above the product range. and want to repeat this for every product in sheet like type 2 then type 3 and so on till end.

I have Max of 8 types of products but returns are 9 only. every report will have all the return but not necessory all type of product.

I tried to do conditional formatt using record MACRO and some editing to it but it is not working. could some one please help me in getting this sorted.

please look at attached file.

[kedarlimaye87]

no one helping