I have 2 columns in my excel 2007 worksheet. I need to compare the values in column A to the values in column B. If the values in column A are not present at all in column B, then I need to have the value that is not present in column B highlighted. I also need to have the values that are in column B, but not in column A highlighted as well. Can anyone help me with this quickly?