Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 "% ...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    It may be a easy problem, you need to uniform number type.

     

ammcleod's avatar
ammcleod
Frequent Visitor
6 years ago

Hi Anonymous ,

I used "Number" instead of "Percentage" for the conditional formatting options and that seems to work for me.

 

 

Hope this helps 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    do not format it it to percentage and try.

     

    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.

  • ammcleod's avatar
    ammcleod
    Frequent Visitor
    6 years ago

    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"