Forum Discussion
Conditional formatting
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 |
2 Replies
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/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
