Forum Discussion

jakeryan56's avatar
jakeryan56
Advocate II
7 years ago

issue with table conditional formatting

I am having trouble adding field based conditional formatting. 

I want the conditional formatting of the first field (platinum revenue) to be based upon the second field (monthly guidance).

However, it wont let me select this field in the conditional formatting screen for some reason.  Is this because it is from a different table?

Need Help

2 Replies

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    Hi jakeryan56

     

    You can apply conditional formatting to the fields even if they are from 2 different related tables. see the image below which show two differnet tables and their fields.

     

     

    Can you share the screenshot of what you are able to see on the conditional format menu and also the relationship structure.

     

    Regards

    Affan 

     

     

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi jakeryan56

     

    The issue seems not caused by different tables. You may check the relationship between the two table.If it is not your case, please share more details for your scenario so that we could help further on it.

     

    Regards,

    Cherie