Conditional formatting based text in another cell

Closed
Report
-
 y88y -
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 reply

Posts
1950
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 9, 2022
148
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