Forum Discussion

craigmon's avatar
craigmon
Helper I
4 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.

 

  • 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

2 Replies

  • 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
    Community Support

    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