Contains & conditional formatting

Closed
Ace - May 13, 2010 at 09:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 09:48 AM
I am having issues with highlighting certain words in a range of cells containing the phrase "intervention plan".

Basically if the cell contains the word, it needs to come up in red and bold.

Anyone help?!

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 13, 2010 at 09:48 AM
You have to use conditional format and use a formula

Say this value is in column A

Then

Select Column A

Goto Conditional Formatting

Enter this formula
=IF(ISERROR(FIND("intervention plan", A1,1)), FALSE, TRUE)

Click on format in the conditional formatting dialog box and choose color and make the font bold