Conditional Formatting for identical numbers

gavinloi

Hi all,

Would there be a way where alteryx workflow would be able to help with conditional formatting or prompting of identical numbers ?

I would require the joining of 2 excels "1" and "2" and if there are similar 'numbers' the conditional formatting would prompt like below.

Example would be John and Amanda with numbers 1 would be flagged as well as Jane and Justina with numbers 3 be flagged.

Thank you!

'1' excel

'2' excel

Final output

Thank you!

2.xlsx

1.xlsx

apathetichell

see attached. basically you can control this with row rules in a table prior to render. You count values and then check the count field which you omit from the table.

conditional colors.yxzp