Forum Discussion
Help with conditional formating and negative + positive percentages
Hi Chilladin ,
Below are the complete steps for setting up the conditional formatting, you can follow each step to end up with the desired results:
1.Click on the drop-down arrow:
2.Click on Font color:
3.Format Style Select the second option - Rules:
4.Setting up the fields that our rules need to be based on is the measure that we created earlier:
5.Set up two rules by clicking on New rule, and finally click OK to get the final result:
Best Regards,
Zhu
Community Support Team
Chilladin , Change Percent to number and 100 to 1 (Percent is for distribution) Percent measure is a number between 0 and 1 (or more)
Move negative first .
Hello Amitchandak,
Thank you for the reply. It helped me understand the percentages, but when I add in the things you mentioned it still doens't color the table:- I changed the percentages to "tal" which is numbers
- I changed the 100 to 1's
Which resulted in no colors this time.
I don't know if I did something that deviated from your instructions.
