Conditional formatting based text in another cell

Closed
y88y - Aug 4, 2015 at 05:14 AM
 y88y - Aug 5, 2015 at 12:07 PM
Hello,

I want to conditionally format the cells in one column (in my case) D, if the cell in the same row but in column K contains one particular word that may appear in a string of text.

I have tried variations of conditional formatting below which have NOT worked (for row 123)

=$K123="*text*"

and

=IF($K123,"*text")

Any help appreciated

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 5, 2015 at 10:49 AM
y88y, Good morning.

Select D1

Try to use this formula as rule at Conditional Format
=IFERROR(FIND("*TEXT*",K1),"")

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
Hi Mazzaropi

I'm afraid that your suggestion didn't work... :(

Any other ideas?
0