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
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"
Idrissshatila
Super User
Super UserAnonymous ,
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
Ahh thank you so much!