Conditional Formatting for identical numbers
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gavinloi
Hope this would work for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! hmm.. seems like i do not have the latest version to show the functionality. Let me try getting it and testing it again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! For the output be able to be in an excel file instead ? I tried to change it instead of browse and it doesn't seem to work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes - but you have to go to excel via render tool.
