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
1925
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 11, 2021
143
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?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!