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
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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
Hi Mazzaropi

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

Any other ideas?