Forum Discussion
craigmon
Helper I
Helper IAnother 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
amitchandak
Super User
Super Usercraigmon , 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