Offset with Conditional Formatting

[SubhasisB]

Hello Friends,
I want to highlight the cells range based on the selection in drop-down list in F16 for both Production and Cost per unit table. Example : Like for last 5 years production, want to highlight the cell range for that product and cost table, for last 6 year the range will expand to 6, for last 4 or 3 years that period range will be highlighted with Conditional Formatting.
Please Help.

[#2 · Accepted solution]

@SubhasisB 

The rule could be as

with formula

=(C$2>($N$2-$J$1))*($B3=$B$16&" "&$F$16)

Similar for second range.

[#3]

Thank You, it works fine

[#4]

@SubhasisB , you are welcome