Forum Discussion
Conditional formatting not working
Hi everyone, I am trying to apply conditional formatting on my column. if my value is more than 15%, it should be red, if less than 15% then it shld be green. However, there is somethin wrong with it? For example, both I have 5 rows with data as 17% but some are red, some are green.... it should all be red. How can i solve this?
Hello Anonymous ,
refer to this, in your case you put 0.15
Anonymous ,
use this and make sure so that all of them are number not percent and where there is max and min to acheive it is just clear the number in the box
7 Replies
Hello Anonymous ,
refer to this, in your case you put 0.15
Thank you sooo much Idrissshatila you saved me. I will remember you forever!!
Hi Idrissshatila I'm curious to know why some values are red but some are green, even though they are the exact same values? 🤔
Anonymous , can you show me your conditional formatting