Another conditional formatting issue

[craigmon]

Hi Guys, I cant for the life of me figure out why this is working. I simply want to change to red if the percentage is over 1.5% and green if below 1.5% . but as you can see, this doesnt seem to work.

[v-easonf-msft]

Hi,  @craigmon 

Could you please tell me whether your problem has been solved?

For now, there is no content of description in the thread.

If you still need help, please share you sample file for further research.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@craigmon , change all percent to number first. and then if you column is a % column then 1.5 is 0.015 .

Means you have clicked % property in measure/column tool