Basic flow for conditional matching and formatting in a tree

Question

I have a record of 20 columns and about 5000 rows.

I have to conduct a conditional checking of data in some columns and then format it accordingly.

For example:

Col A - IDs

Col B - Country

Col C - "xyz" number (121 or 234)

Col D - type ( either p or q)

Col E - (column which needs to be checked) (YES or NO values)

So basic flow goes like:

A country is selected like USA out of all countries in column B. All the rows (with USA) will be checked for Column C and Column D.

If column C has 121 and corresponding D has p then E must contain YES.  (If it rather contains no then that cell in E must turn yellow. But if it contains YES only, then it turns green.)

If column C has 121 and corresponding D has q then E must contain NO.    (similar to above)

similar goes with 134.

And then similar with non USA countries as a whole.

hellyars · Answer

Switched to Bool, but basically the same.

ConditionalMatchV2.yxzp

hellyars · Answer

@ShantanuDagar

Never try to do Alteryx while talking on the phone.  Found another minor error and fixed it. I replaced the workflow above with a corrected version.

hellyars · Answer

I had a minor error in my first formula.  I just replaced the workflow.  If Test = 1 (True).  If Test =2 (False).