Conditional formatting based text in another cell

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

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)




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

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?