problem in conditional formatting in a table

[Giada90]

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

[v-yalanwu-msft]

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]

@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]

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.