8 Replies Latest reply on Feb 8, 2019 7:43 AM by Suresh Reddy

    Conditional Formatting in comparisions

    Suresh Reddy

      Hi All,

       

      We are comparing last 2 years sales as shown below.

      Our requirement is if 2018 Sales < 2017 sales then the line should be in RED color.

      In this case in the month of NOV 2018 Sales is < 2017 Sales.

      Is it possible to change the 2018 line color to RED  where 2018 sales< 2017 sales  for NOV as shown below.

      Can anyone please help me on this?

       

       

      Thanks,

      Suresh.