Conditional formatting on a table column based on values from another table

Hi!
Based on the second table (bottom visual) if “Parts in Transit” >0 color the “Parts Count” column in the Top table a specific color. Then if “Parts in Transit” = 0 and “parts not available” >0 color the “Parts count” row a specific color etc.

Is this possible? Thanks!

You need to join tables first then add conditional formatting

1 Like

Hi! Thank you @vaquarkhan for your reply. I did join the datasets and posted a similar question on how to achieve my use case with the joined table, because I can’t figure it out with the joined data either. This is the question: Conditional formatting (color a row) based on values from another column in the dataset