View Single Post
  #1   Report Post  
mansure
 
Posts: n/a
Default comapre two lists

Hi
once i did this, but now i've forgotten the formula.
I want to comapre two lists, I want to use a conditional formatting, so that
those cells that their contents doesn't exist in the other list would be
marked in color gray.
if anyone can help please! last time I remeber I used the function countif().
thanks a lot.
Mansure