How to loop through a column and highlight cells if not found in range

[JonHuff]

here is my code and what I am trying to do - I want to start at row 2 and for each value in column B see if that cell value exists in range B10000:B10100. If it does exist, then go to the next row and evaluate, if it doesnt exist then highlight that cell adn go to the next row and evaluate. do this until column B is empty. it is highlighting all rows, even those where the cell value is in that defined range. HELP and Thank you in advance

Option Explicit
Sub Crosscheck()

Dim x As Integer

'Application.ScreenUpdating = False
'Application.DisplayAlerts = False


x = 2
Do Until Cells(x + 1, 2).Value = ""
If Cells(x, 2).Value <> ("B10000:B10100") Then


Cells(x, 2).Select

Worksheets("investor file").Cells(x, 2).Interior.ColorIndex = 3
x = x + 1
Else
x = x + 1
End If

Loop

'Application.Quit
End Sub

[Guido Geurs]

("B10000:B10100") has not the values of the range!
How to do:
Put the values from "B10000:B10100" in an array and check the values from B2... with the values in the array like:

For i =1 to ubound(array)
  if Cells(x, 2).Value <> array(i) then
  ..
  else
  ..
  end if
next

[JonHuff]

i am sorry but i am not an excel vba programmer - im used to access vba - you said

"for i=1 to ubound(array)"
"if cells(x,2).value <> array(i) then"

what do i use for "ubound(array)" and "array(i)"? - the more explicit you could be would help

i tried to Dim i as array - its not an option, so am I supposed to Dim i as Integer then what?

[Guido Geurs]

See attachment: run the macro.

[JonHuff]

thats it - thank you very much - if i were in belgium right now i'd buy you dinner - have a wonderful evening