Related:

- Excel conditional formatting if cell contains specific text
- Excel conditional formatting formula if cell contains text - Best answers
- Conditional formatting if cell contains text - Best answers
- Excel conditional formatting if cell contains any date - How-To - Excel
- Excel conditional formatting merged cells ✓ - Forum - Excel
- Excel conditional formatting if cell contains any text ✓ - Forum - Excel
- Excel conditional formatting range of cells ✓ - Forum - Excel
- Excel conditional formatting more than 3 colors ✓ - Forum - Excel

Zohaib R

- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Moderator
- Last seen
- December 13, 2018

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

View all 15 comments

Report

Matt

its 2016 and this answer is still good! I used it to format cells that contained the word "Medium" but the look up was "Medium-8" through to "Medium-18" worked perfectly. Cheers Zohaib R :)

Report

Chris

Thanks for this post, saved me a lot of time.

Report

K

June 2017 - Thanks so much Zohaib, I was running in circles and wouldn't have thought of this (self taught, and I still don't understand its logic, but it works so I'm ecstatic!) ~K

Report

Slow Bo

Thank you! Finally, a solution that worked for me! I needed to highlight every cell that contained 'yes' and this did it.

Report

Mooseman

Thanks

Harry

Hi, I have 2 columns. I want to chenge the color of column B based on value in column A. If value in A is greater than or equal to zero, color should be green else red(I am doing this with conditional formatting and it works fine.)

Problem:

when the color is changing I want to add a text On track and color green or else delayed and color red. Is that possible?

Problem:

when the color is changing I want to add a text On track and color green or else delayed and color red. Is that possible?

Zohaib R

- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Moderator
- Last seen
- December 13, 2018

Hi Leanne99,

Use the below mentioned steps to apply conditional formatting to the cells.

1. Select the cells where you want to apply the Conditional Formatting.

2. Click Conditional Formatting from the top ribbon.

3. Select New Rule.

4. Click Use a formula to determine which cells to format.

5. Enter the below mentioned formula in Format values where this formula is true:

=ISNUMBER(SEARCH("first aid",F13))=TRUE

6. You will all the cells which have the word "first aid" in it, the cells against them will be highlighted.

Please revert for clarification.

Use the below mentioned steps to apply conditional formatting to the cells.

1. Select the cells where you want to apply the Conditional Formatting.

2. Click Conditional Formatting from the top ribbon.

3. Select New Rule.

4. Click Use a formula to determine which cells to format.

5. Enter the below mentioned formula in Format values where this formula is true:

=ISNUMBER(SEARCH("first aid",F13))=TRUE

6. You will all the cells which have the word "first aid" in it, the cells against them will be highlighted.

Please revert for clarification.

leanne99

Hi Zohaib

thank you so much for your reply. I am using Office 2011 for Mac. I have tried using and OR formula and this appears to be working although a little complex.

Again thank you for your reply

regards

Leanne99

thank you so much for your reply. I am using Office 2011 for Mac. I have tried using and OR formula and this appears to be working although a little complex.

Again thank you for your reply

regards

Leanne99

Grinty

- Posts
- 1
- Registration date
- Thursday February 28, 2013
- Status
- Member
- Last seen
- February 28, 2013

This is particularly helpful, but can it be extended to respond in other colours where the answer in F13 may not be "first aid", but something else like "health & safety"?

So an either/or function of some sort?

So an either/or function of some sort?

Zohaib R

- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Moderator
- Last seen
- December 13, 2018

Hi Grinty,

Please check the below mentioned link:

https://ccm.net/forum/affich-689619-conditional-formatting-change-fontcolor-based-on-another-cell

I have used AND Logical Operator to select three different criterion. Check if this helps.

If you need further assistance please post some more details about your datasheet. In addition, you can upload a sample file to: https://authentification.site

Note: Before you upload any files please make sure there is no personal or confidential information contained in it.

Please check the below mentioned link:

https://ccm.net/forum/affich-689619-conditional-formatting-change-fontcolor-based-on-another-cell

I have used AND Logical Operator to select three different criterion. Check if this helps.

If you need further assistance please post some more details about your datasheet. In addition, you can upload a sample file to: https://authentification.site

Note: Before you upload any files please make sure there is no personal or confidential information contained in it.