Help needed for "find"

[Neitrino]

I have a huge column A with some data, on another sheet or on the same sheet I have another column B with some other data...

Is it possible and how should I tell excel to search individualy all values from column "A" in column "B" and if column "B" contains values that exist in column "A" then let the next right neighbouring cell (to column "A" cell) turn into green or let there appear "ok" notification...


May u pls help i need this urgently
thank u

[Bob Phillips]

Look at conditional formatting http://www.contextures.com/xlCondFormat01.html

[Armando L Franco]

Insert a column next to A. This will make column B your column C.
Then enter this formula (I am assuming you start in cell b2).
=if(iserror(vlookup(a2,C:C,1,0)),"","OK")
This will display OK if it exists, leave it blank if it does not.