Forum Discussion

DevadathanK's avatar
DevadathanK
Icon for Resolver I rankResolver I
6 years ago
Solved

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

Hi Community!

<Message deleted>

Thanks for any help!

 

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

3 Replies

  • 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's avatar
      v-zhenbw-msft
      Icon for Community Support rankCommunity Support

      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's avatar
        DevadathanK
        Icon for Resolver I rankResolver I

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

        <Message deleted>