Forum Discussion

Giada90's avatar
Giada90
Helper IV
3 years ago

problem in conditional formatting in a table

Hi,

I have a problem with conditional formatting in a table: if I want to use a rule I can' change between number and percentage in the rule, why?

Thanks

Need Help

3 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Giada90 ;

    I tested the possibility to switch percentages and numbers, provided that the previous value is less than the latter value (> small value< large value - it is logical)
    but I don't quite understand your intentions; Can you share small examples and the results you want to output?

     


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Giada90's avatar
      Giada90
      Helper IV
      3 years ago

      v-yalanwu-msft thanks, the image is just an example not mine, I don't have sample data but sometimes  it happened that I can't change number or percentage

      • v-yalanwu-msft's avatar
        v-yalanwu-msft
        Community Support
        3 years ago

        Hi, Giada90 ;

        Well, if you have a case you can send it to me, I haven't come across this situation. Unless the minimum value is greater than the maximum value (because it is not logical)


        Best Regards,
        Community Support Team _ Yalan Wu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.