Forum Discussion
Solved
Offset with Conditional Formatting
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.
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.
The rule could be as
with formula
=(C$2>($N$2-$J$1))*($B3=$B$16&" "&$F$16)Similar for second range.
