Forum Discussion
conditional formatting rule
The percentage setting looks only at the range from low to high then formats based on which bucket the value falls into. It does not look at the value itself.
If you have an actual % value like margin rate or completed % you need to use number to format the field then it will look at the actual value. .33 = 33% so the 30% value is green and the 40% value is yellow:
The percentage setting looks only at the range from low to high then formats based on which bucket the value falls into. It does not look at the value itself.
If you have an actual % value like margin rate or completed % you need to use number to format the field then it will look at the actual value. .33 = 33% so the 30% value is green and the 40% value is yellow:
Thank you very much. Your example is out of this world! I learnt it easily with your example. Thanks once again. Appreicate it.