Conditional formatting question

Assuming your first column is A and second column is B. And the data can be there in the range A2:A100, then select the range A2:A100 and make New Rule for conditional formatting using the formulas given below...

For Green

=ISNUMBER(MATCH(A2,$B$2:$B$100,0))

For Red

=AND(A2<>"",ISERROR(MATCH(A2,$B$2:$B$100,0)))

Change the column and range reference as per your need.
Hope this helps.

Hi Sktneer,

Thank you for the reply. I may be doing something incorrectly because it's not working the way it should. Just to simplify the example in column A I put in some sample data, numbers 1 through 10 through cell A10. In column B I applied the formulas you kindly provided and then entered some data to see if it would respond correctly. Here are the issues I found:

For some reason if the value doesn't exist, in this case I chose the number 11, it did not make the cell red.
If the numbers did match it would highlight the cell next to the value in column A with red instead of highlighting the cell in column B with green.
If the value happened to match and be in the same row the cells would turn white.

Maybe I did a poor job of explaining what I need? Column A will be populated with data, column B's job is to search column A for the data and if it matches, no matter what row it's in, turn it green, if it doesn't, turn it red.

To apply the conditional formatting I simply went to new rules and used the "use a forumla to determine which cells to format" section, is that correct? Thank you again for the help!