Conditional Formating for EXACT word or phrase

I found the following post:

"In your questions, please include only the information directly related to one specific question. In this case, I'll assume your actual question is: in a particular range, how do I shade only those cells that contain the word "apple" or "pear" etc?

In range A1:A5, enter:

apple
pear
orange
berry
grape

How can you shade all cells in col C that contain one of these words?

In D1, enter:

=SUM(IF(ISERROR((FIND($A$1:$A$5,C1))),0,1))

as an array (after entering formula in cell, instead of hitting Enter, hit Ctrl-Shift-Enter). Then copy the D1 formula down col D.

Select col C. From main menu, choose Format, Conditional Formatting, formula is, =(D1>0), format, patterns, [red], OK, OK.

All col C cells that contain one of the key words will now have red pattern. "

The above works great but if I want to look for the phrase "the apple" it fails, or if I want to look for the exact match of "apple" it fails. For example I can type snapple and it will give column D a 1. Any idea how to make it an exact match or match on a phrase?

Thanks

The changing D1 formula to:

=SUM(IF(ISERROR((FIND(" "&$A$1:$A$5&" "," "&C1&" "))),0,1))

CSE confirmed and copied down.

Try =SUM(IF($A$1:$A$5=C1,1,0)), confirmed with Ctrl+Shift+Enter and copied down.

Originally Posted by NBVC

The changing D1 formula to:

=SUM(IF(ISERROR((FIND(" "&$A$1:$A$5&" "," "&C1&" "))),0,1))

CSE confirmed and copied down.

Solved

Thank you very much

PS how do I mark thread as solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

If you want to use this for conditional formatting then you don't really need to use a helper column, just select column C and use this formula in conditional formatting

=COUNT(FIND(" "&$A$1:$A$5&" "," "&C1&" "))

format as required