8 Replies Latest reply on Dec 10, 2017 7:02 PM by Michelle Barrineau

    Conditional formatting question

    Michelle Barrineau

      Hi,

      Thanks in advance for your help!

      I'm trying to set a condition where if the value in a column is higher or lower than the value in the first column, it turns a color.

      Here's an example:

       

      Since the value for the second column (ALB/SFY California) is lower than that in the first column (XAOC...) for the first line (Commodity). 

      -13.8% is lower than 0.0% so I would like it colored red.  I would like to do this with all of the columns with the XAOC first column as the reference.

       

      Is this possible?

       

      Thanks so much,

      Michelle