Search Through Rows Of Specific Column

I am trying to develop a macro that does the folllowing

1) Takes the value from a specified column of a sheet in the workbook and sequentually go the the values of that column and compares those values to another sheet in the workbook

For ex: sheet1 in column A row 1 has string value abc123 and sheet2 column A row 1 has value 123abc. I want to compare these two values from different sheets.

2) However if the values don't match I would like to take the value from sheet1 and see if it is in the list on sheet2.

3) If the value from sheet2 isn't on the list from sheet1 then paste that row information to sheet3

So far this is what I have. All it does now is go through both lists and compares the values but I am not sure how to single out those values for conditional formating. I am sure that the singled out values will need to be derived dynamically since I won't know what or when the values will be up for conditional formatting.

Dim LoopCount As Integer
Dim RangeCount As Integer
Dim CellVal As String
Dim CellIncrement As Integer
Dim ErrorCount As Integer
Dim PasteConfirm As Boolean

[Code] .........