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