Anomaly Detection

[ajaydhamrait]

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]

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

[ajaydhamrait]

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]

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.