Forum Discussion
Conditional Formating
Hello,
I am trying to apply conditional formatting for value "Yield". However, I am struggling to understand what rule to apply to meet my request. I want the value under Yield be green if the value is equals or greater than the value in STD yield column. Every raw is a different product , so I cannot use regular rules like "if yield is > 50" because each product has it own standard. Thank you. Any help is appreciated!
| Product | Yield | Standard Yield |
| A | 70 | 61.5 |
| B | 51.5 | 52 |
| C | 75 | 70 |
You then need to create a measure where you use IF condition.
Use the measure here
5 Replies
Hi Amine ,
Thank you. However, if I understand your colution correctly, it would not work in the case below:
I need it to be red because the yield is lower than standard yield. So, I cannot use a rule if yield value is > a certain number. What I am trying to do is to set up a rule when yield value is >= Standard Yield value than green, When value is , Standard Yield value than red. But I am struggling to undersntad how to set up such rule. Thank you
Yield Standard Yield 40% 50% You then need to create a measure where you use IF condition.
Use the measure here
Thank you so much, aj1973 !! This made my day. I just followed you on all social media.
Do you know if it is possible to do the same but for the columns?
Thanks
Hi KK111,
Multiple rules for conditional formatting can be configured. I think you can add a new rule for each of your requirements.
I hope this helps.
