Previous Topic Next Topic

Contains & conditional formatting

Closed
Ace - 13 May 2010 à 09:16
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 May 2010 à 09:48
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 May 2010 à 09:48
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses