|No, you meant to say what you said in Response # 2: cell A1 and cell B1.|
A and B are Columns
1 and 2 are Rows
A cell is the intersection of a Column and a Row, therefore A1 and B1 are cells
There are (at least) 2 ways to determine if the value in Column A matches the corresponding value in Column B.
Option 1: Formula Method:
Enter this formula in C1, then double click the Fill handle. That should AutoFill the formula down to the bottom of your list, assuming there are no blanks in the list of values in Column B:
The formulas will return TRUE when the values match and FALSE when they don't.
Option 2: Conditional Formatting
Select Column B and apply this Conditional Formatting rule and choose the formatting of your choice. Whenever this Rule is TRUE, the cell in Column B will be highlighted with the format you chose:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.