Hi
try the following
- select your cells in column B (assumption: you start in row 1)
- goto 'Format - Conditional Format'
- enter the following formula in this dialog:
=COUNTIF($C$1:$C$300,B1)0
- choose a format for these cells

you may also have a look at
http://www.cpearson.com/excel/duplic...tractingCommon

--
Regards
Frank Kabel
Frankfurt, Germany

"vivian" schrieb im Newsbeitrag
...
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?