Related:
- Conditional formatting based text in another cell
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Count if cell contains number - Excel Forum
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
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
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
Aug 5, 2015 at 12:07 PM
I'm afraid that your suggestion didn't work... :(
Any other ideas?