Logical error with 'Conditional Formatting of Table Field' - By Rule

[DevadathanK]

Hi Community!

<Message deleted>

Thanks for any help!

[DevadathanK]

I tried the same formatting for yet another column and here another value, under 95% got a green background.

Now i think that which ever is the highest value in a particular column, the colour green gets added to its background. 

<Message deleted>

[v-zhenbw-msft · Accepted solution]

Hi @DevadathanK ,

Please try to save your rule as decimals, and use number.

And you can refer the Considerations and limitations of conditional table formatting.

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DevadathanK]

Hi @v-zhenbw-msft ,
Thank you so much! Its working now. I made the changes according to your suggestion.

<Message deleted>