Anomaly Detection

Question

Hi, I'm trying to form an Anomaly Detection tool and I was wondering if there's a way to highlight one of the Excel output cells a different colour if there is a certain word within the data that shouldn't be there? I hope my question makes sense.

Many thanks

Luke_C · Answer

Hi @ajaydhamrait

You should set-up a column rule in the table tool. Here's an example - I think you made multiple posts on this topic.

New Workflow3.yxmd

ajaydhamrait · Answer

Thank you for that, I've had a look but it doesn't give me the information that I need. For instance, highlighting an Excel cell Yellow if it contains the word 'Today' from the phrase 'Happy Hour Today' - would I need to input a formula for this?  New to Alteryx, apologise if it's an obvious solution.

Luke_C · Answer

You could use the table tool and assign row level/column level rules. Check out this link for more info