how to search a cell that existing in another column
I meant to say:
=MATCH(B1,$C$1:$C$300,0)
"Aladin Akyurek" wrote in message
...
"Frank Kabel" wrote in message
...
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
[...]
Just
=MATCH(B1,$C$1:$C$300)
would be faster though.
|