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)


[TABLE="class: grid, width: 350"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]sales dept[/TD]
[TD]list of participants[/TD]
[TD]sales staff participating[/TD]
[/TR]
[TR]
[TD]mary1[/TD]
[TD]linda1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]john1[/TD]
[TD]eric1[/TD]
[TD]john1[/TD]
[/TR]
[TR]
[TD]jack1[/TD]
[TD]erica1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]alex1[/TD]
[TD]adam1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mary1[/TD]
[TD]david1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sarah1[/TD]
[TD]sarah1[/TD]
[TD]sarah1[/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much.

 

[Michael M]

For your conditional Format, try

=C2<>""