Formatting cell colour if it contains a text value defined in an excel column

[srea541]

Is there a way to format cells using the table tool based on whether a cell contains a value within an excel sheet? 

These are the values I would like to search for in another table, and if any of these values are found in the other table, I would like to change the cell colour to red.

Is this possible?

Many thanks!

[atcodedog05]

Hi @srea541 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[srea541]

Hi @atcodedog05 

The input file attachment is the data that is being read in, and the expected output file is how I'd like it to look when compared against the "negativewords" excel file.

All files attached. 

[OllieClarke · Accepted solution]

Hey @srea541 

here's a way to do it:

[binay2448]

Find attached my solution hope it will help you..

[srea541]

Thank you so much!!!

[srea541]

@OllieClarke so those formulas will change the cell colour if it contains that string - the word "huge" is triggering a change in the cell colour because it detects "hug" - how would I adapt it so it has to be exactly that string?

[atcodedog05]

Hi @srea541 

I would suggest to use find and replace tool because it has match words only option. Give it a try.

Workflow:

Hope this helps : )