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...
Hi,
Here is how to do this:
Formatting measure =
IF(MAX('Table (27)'[Score])>=5,"Green","Red")
Place this measure as the conditional format:
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
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 |