Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created a Conditional formatting rule but I don't get the results I would expect
I am getting (two results in Yellow are wrong
94.81% is not greater than 95%
7.35% is not 0%
Any help guidance would be appreciated
Solved! Go to Solution.
@Anonymous , Make absolute/number and use .95 to 1 (if column is marked as % column)
.01 to .95
and is 0 and try
Sorry does not work and the results are worse
Yes it is a % Column
Thank you for your help, works great 🙂
@Anonymous , Please change the percent to number also. The column after .95 value and 1 value, I all rows
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |