Forum Discussion
Solved
Conditional Coloring not working
Hi, I had one report working on Conditional Coloring, but this new one I can't seem to get it to do conditional coloring for some reason. I have a column PCT Complete that in the data is ...
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.
You may change the Rule no. 3 as follows:
Rule 3 : > 0.99 & <=Max (You have to type Max in the box)
Still no luck after changing..I have something 5% in red and nothing in yellow.
Here is the setting (I did change to Max, but when I went back in, this is what it shows):