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...