Forum Discussion
condional formating
I have a Rules with percetage format. So in card it gives a certain percentage value. I want to apply conditional formatting where if > 2,4% "Red" and >=2.0% and 2.4% "Yellow", 0% and 0.2%= Green b...
Thanks audreygerred
I try a condition
- For green, change .2 to .002 (.2%)
- For yellow, change .2 to .02 (2%) and. 24 to .024 (2.4%)
- For red, change .25 to .024 and you can leave the 1 alone as long as you'll never have over 100% as a value. Otherwise, make 1 be 10 just to be on the safe side.
but finally this picture
2,6 % this is a Total i want a colour a red
You're welcome!
For green did you want it to be 0.2% (as stated in original post) which is .002, or do you want it to be 2% which would be .02?
If this solved your issue, please mark as solution.
Hai
To condition follow a orginal post but i try a condition color do not match in rules, i want to try your give solution that result all persentase its red colour
is there any solution?
Thank You
Hello! They're all red because I wrote the answer to match what you originally wrote which was green is 0% to .2% so I advised to use .002. I think you meant for green to be 0% to 2% so it should be .02 on green 🙂