How to use conditional format based on text?
Solved
Leanne99
Mooseman - Jan 24, 2018 at 01:39 PM
- Posts
- 1
- Registration date
- Friday November 9, 2012
- Status
- Member
- Last seen
- November 9, 2012
Mooseman - Jan 24, 2018 at 01:39 PM
Related:
- Excel conditional formatting if another cell contains specific text
- Excel conditional formatting if cell contains specific text - Best answers
- Conditional formatting if cell contains text - Best answers
- Conditional format based on another cell containing text - Forum - Excel
- Highlight cell if another cell contains any text ✓ - Forum - Excel
- Conditional formatting with multiple rules and blank text cells ✓ - Forum - Excel
- Conditional formatting of a cell if another cell is blank - Forum - Excel
- Excel conditional formatting if another cell is between two values ✓ - Forum - Excel
7 replies
Zohaib R
Updated on Jan 13, 2019 at 03:17 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Updated on Jan 13, 2019 at 03:17 PM
Hi Leanne99,
You are following the right steps, instead of "f13=first aid" enters the below mentioned formula:
For step by step help on this, in your reply, please mention the version of Microsoft Excel you are using (such as Excel 2003, 2007, 2010, etc.)
Please do write back to us.
Thanks & Regards
Zohaib R
#iworkfordell
You are following the right steps, instead of "f13=first aid" enters the below mentioned formula:
=ISNUMBER(SEARCH("first aid",F13))=TRUE
For step by step help on this, in your reply, please mention the version of Microsoft Excel you are using (such as Excel 2003, 2007, 2010, etc.)
Please do write back to us.
Thanks & Regards
Zohaib R
#iworkfordell
Jan 8, 2014 at 06:05 AM
Mar 4, 2014 at 10:45 PM
Thanks.
Apr 9, 2014 at 11:33 AM
Jul 22, 2014 at 08:03 AM
how can it be possilbe
Nov 6, 2015 at 11:31 AM