vlooup +conditional formatting

[lezawang]

Hi
I have 2 columns and I am using vlookup to find names in the second columns as below.
The vlookup function as follow

=IFERROR(VLOOKUP(A2,$B$2:$B$101,1,0),"")

My question, how can I use conditional formatting to highlight cells which has text in the 3 column? I tried to highlight he C column and then wrote the function below but all got highlighted?

=istext(c2)

sales dept	list of participants	sales staff participating
mary1	linda1
john1	eric1	john1
jack1	erica1
alex1	adam1
mary1	david1
sarah1	sarah1	sarah1

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Thank you so much.

 

[Michael M]

For your conditional Format, try

=C2<>""