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...
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
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
Idrissshatila Sorry I cant upload pictures on here but it goes
if value > 0.15 [Number] and < 0.3 [Number] then "green"if value >= 0 [Percent] and < 15 [Percent] then "red"