Forum Discussion
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
- amitchandakSuper User
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-msftCommunity 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