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

 

[njimack]

You mean like this? You could also build this into conditional formatting so that the cells turn green.

Excel Workbook
	A	B	C
1	Random text 1	blah	OK
2	Random text 2	blah
3	Random text 3	Random text 1
4	Random text 4	blah
5	Random text 5	blah
6	Random text 6	Random text 9
7	Random text 7	blah
8	Random text 8	blah
9	Random text 9	blah	OK
10	Random text 10	blah
Sheet1

 

[AlphaFrog]

Conditional Formatting example

Excel Workbook
	A	B
1	This	Formatting
2	is	Stuff
3	a	test
4	test
5	of
6	Conditional
7	Formatting
Sheet

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =AND(A1<>"",COUNTIF(B:B,A1))	Abc
A2	1. / Formula is =AND(A2<>"",COUNTIF(B:B,A2))	Abc
A3	1. / Formula is =AND(A3<>"",COUNTIF(B:B,A3))	Abc
A4	1. / Formula is =AND(A4<>"",COUNTIF(B:B,A4))	Abc
A5	1. / Formula is =AND(A5<>"",COUNTIF(B:B,A5))	Abc
A6	1. / Formula is =AND(A6<>"",COUNTIF(B:B,A6))	Abc
A7	1. / Formula is =AND(A7<>"",COUNTIF(B:B,A7))	Abc

 

[jolivanes]

This marks column A (and puts ok in column B) of Sheet3
Info it compares with is in Sheet2, column A

Sub CheckFromSheet2ToSheet3()
'remove any previous coloring
  Range("A:A").Interior.ColorIndex = 0
  Set chsht = Sheets("sheet2")
  For Each ce In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
    If WorksheetFunction.CountIf(chsht.Range("A:A"), ce.Value) > 0 Then
      ce.Interior.ColorIndex = 4
        ce.Offset(, 1).Value = "ok"
    End If
  Next ce
End Sub