How to use conditional format based on text?

Solved
Leanne99
Posts
1
Registration date
Friday November 9, 2012
Status
Member
Last seen
November 9, 2012
- Updated on Jan 13, 2019 at 03:17 PM
 Mooseman - Jan 24, 2018 at 01:39 PM
Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?
System Configuration: Mac OS X Lion (10.7) / Firefox 16.0

7 replies

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
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:

=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
86
Thx a lot
0
Great! It works now. I spent more time to find this.
Thanks.
0
BIG HELP. Thank you
0
Hi That is OK and good , but I a want a specific "word" in different coulumn .
how can it be possilbe
0
specific word just use the formula [if the column your looking for is A and the reference is A2] =A2="word". Make sure it is relative formatting and copy it down.
0