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
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.