1 Reply Latest reply on Sep 27, 2018 9:44 AM by Joe Oppelt

    Conditional Formatting the Total Value alone in a column based on formula

    sathish Chidambaram

      Dear All,

       

      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.

       

       

      Thanks.