I'd like to be able to change the background color of the Total value’s in Percent column based on a formula. Expected results are shown in the below image of excel sheet. If I place the calculated filed on color, entire table is updated. Color is depend on +/- 10 from Exp sales value, for Green or Red.
Attached the sample workbook. Looking for your valuable suggestions.