Forum Discussion
Conditional Coloring not working
I think I found a solution to it.
The field PercentComplete is of Data type "Decimal Number" and Format "Percentage" with 0 decimal places.
A new field needs to be created to convert this into a whole number (i.e. newfield = PercentComplete * 100) and this new field needs to be of Data type "Whole number" and Format "General" asd Auto as decimal places.
In the conditional formatting, I had to use this new field that is a whole number and not the percentage field.
Dont think that will work, as my last condition would be > 99 Percent and then what is the other side, as it only allows 100 percent, but I have values as 153 percent.
OK. So you have to work with decimals.
Try :
Rule 1 : >=0 & <= 0.76
Rule 2 : > 0.76 & <= 0.99
Rule 3 : > 0.99 & < 10
For Rule #3 you mention 10 would that be then considered 1000% ?
Yes, that's it.
That did not work as I have a few at 25% as yellow and not green, so at 8% as red and not green and one that is 151% as yellow and not red.
Here is my setup:
My field is set to Data Type: Decimal Number, Format: Percentage and no decimal places