issue with table conditional formatting

[jakeryan56]

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?

[v-cherch-msft]

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

[affan]

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