Forum Discussion

craigmon's avatar
craigmon
Icon for Helper I rankHelper I
5 years ago
Solved

Another conditional formatting issue

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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

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