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 hig...
The rule could be as
with formula
=(C$2>($N$2-$J$1))*($B3=$B$16&" "&$F$16)Similar for second range.
The rule could be as
with formula
=(C$2>($N$2-$J$1))*($B3=$B$16&" "&$F$16)Similar for second range.
Thank You, it works fine
SubhasisB , you are welcome