View Single Post
  #1  
Old March 27th, 2004, 11:40 PM
vivian
external usenet poster
 
Posts: n/a
Default how to search a cell that existing in another column

I need to compare column B and column C. If the cell in
column B exist in Column C, hight light it. Else nothign
happened. There are 120 values in column B and 250 values
in column C. How can i do this? is there any function
that i can use?