Skip to main content

Hello,

 

I am trying to create conditional formatting based on two numerical criteria. I have a YoY Change and a YoY % Change column. I want my conditional formatting to color the numbers red where both statements are true YoY Amt Change >20 AND YoY % Change >.2. Additionally, I have a set of total columns and then the categories that equal total. I want only the columns where those conditions are true to be colored red. Currently, in some cases like row 1 it is not considering the AND and coloring cells incorrectly.

 

Additionally, this seems so silly but I have not figured it out yet. When I go to the color palette to assign my colors I cannot find black for the statements that are not true. Ideally, I would like all true statements red and everything else black text.

 

Thank you for any help or suggestions!

10 answers
  1. Aug 18, 2017, 3:00 PM

    Hi Anna,

     

    Upfront when i came into your workbook I found the following:

     

    YOY Amt Color: IF [YoY Amt Change]>19 AND [YoY Amt% Change]>.2 THEN 1 ELSE 0 END

     

    Should "19" not be "20"?;)

     

    Hi Anna, Upfront when i came into your workbook I found the following: YOY Amt Color: IF [YoY Amt Change]>19 AND [YoY Amt% Change]>.2 THEN 1 ELSE 0 END Should

     

    Regards,

    Norbert

0/9000