Conditional formatting not working

[Anonymous]

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? 

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

refer to this, in your case you put 0.15

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

refer to this, in your case you put 0.15

[Anonymous]

Hi @Idrissshatila I'm curious to know why some values are red but some are green, even though they are the exact same values? 🤔

[Idrissshatila]

@Anonymous , can you show me your conditional formatting

[Anonymous]

@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 · Accepted solution]

@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

[Anonymous]

Ahh thank you so much! 

[Anonymous]

Thank you sooo much @Idrissshatila you saved me. I will remember you forever!!