Forum Discussion
Conditional formatting in tables
Hi everyone, In my report, I have a matrix with an overview of 12 employees. In this Matrix, the employees can see how many sales they made, their budget and "% on budget". In the column with "% ...
Hi Anonymous ,
It may be a easy problem, you need to uniform number type.
ammcleod Anonymous
It still doesn't work for me even though I change it to numbers. I have formatted the number as a percentage and that is probably the reason (see the screen below).
Anonymous
I took another look at your first screenshot and noticed that the first 2 rows of rules use Percentage at the start of the rule then Number at the end.
Try and make sure all rules use Percentage and see if that works?
i.e. "Greater than or Equal to" [your number] "Percentage and "Less than or Equal to" [your number] "Percentage"