Conditional Formating

[KK111]

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

[Anonymous]

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. 

[KK111]

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%

[aj1973 · Accepted solution]

You then need to create a measure where you use IF condition.

Use the measure here

[KatenokKatya]

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 

[aj1973]

hi @KK111 

like this?