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!
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"?;)
Regards,
Norbert