How to use conditional format based on text?

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

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 responses

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.

Thx a lot
Hi Pete
How can I make action repeat in another row cells downwards?
The action just works in one column.