Conditional formatting

[Jedahn]

Hello Everyone,

I applied conditional formatting in score column that if the score of employee is >= 5 it will be colored as green and < 5 will be red. But for employee number 4&5, they only need >= 4 score to achieve the green color. What should be my next step to accomplish this kind of formatting?  Thank you very much!!

Applied conditional formatting

Employee_Name	Score
Employee 1	5
Employee 2	4.9
Employee 3	6
Employee 4	4.2
Employee 5	4

Expected result

Employee_Name	Score
Employee 1	5
Employee 2	4.9
Employee 3	6
Employee 4	4.2
Employee 5	4

[ValtteriN]

Hi,

Here is how to do this:

Formatting measure = 

IF(MAX('Table (27)'[Score])>=5,"Green","Red")

Place this measure as the conditional format:

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Jedahn]

Hello. my expected result should be employee 4 and 5 will be marked as green if their score is just >= 4. like in the second table i provided

Employee_Name	Score
Employee 1	5
Employee 2	4.9
Employee 3	6
Employee 4	4.2
Employee 5	4