Conditional Formatting in Tables — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Conditional Formatting in Tables

Received Response
51
Views
2
Comments

Summary

Conditional Formatting in Tables

Content

Ok, here's a simple question, but I haven't been able to find any documentation or community questions about it...

Can you apply conditional formatting to table cells?

If so, a hint would be appreciated.

Thanks,

Stu

Answers

  • Rakesh Chhoria-Oracle
    Rakesh Chhoria-Oracle Rank 2 - Community Beginner

    Hi,

    There is an option to set Colors for values where we can select multicolor palettes. Attaching an image of the same. I had set the mid point as 2,000,000 in the below image.

    Hope this helps.

    MultiColourValues.JPG

    Thanks

    Rakesh

  • StuMoffitt
    StuMoffitt Rank 4 - Community Specialist

    Hi Rakesh,

    Thanks for the advice. I finally had a chance to try this. It does, indeed, work as you showed and I would never have discovered the methods of traversing the depths of the color management palette without your help.

    One comment: this seems to be the way to control the color of the entire row, not an individual cell (as in Excel). It gets me closer but not quite all the way.

    Thanks again,

    Stu