3 Replies Latest reply on Oct 12, 2018 12:28 AM by Sairam MVV

    How to Chnage the background Colour of the Sheet based on Calculated field

    Praks Sha

      Hi Experts.

       

      I am in need of your help urgently.

       

      Please let me to know how can we change the sheet's background colour based on a Calculated field named 'ColourChange'

       

      ColourChange =

      if (Sum(Current Sales) - Sum(Previous year Sales) ) > 0

      Then BackgroundColour = Green

      ElseIf  (Sum(Current Sales) - Sum(Previous year Sales) ) < 0

      Then BackgroundColour = Red

      Else  (Sum(Current Sales) - Sum(Previous year Sales) )  = 0

      Then BackgroundColour = Yellow

      End.

       

       

      Thanks.