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

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!

Text Mining

Data Investigation

Accepted answers

OllieClarke

Hey @srea541

here's a way to do it:

words.yxmd

All comments

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.

Hey @srea541

here's a way to do it:

words.yxmd

binay2448

Find attached my solution hope it will help you..

Formatting cell colour.yxmd

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 : )

color words.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703