I need some help.....The following is the senario I need to accomplish with a
macro of some sort but am lost on how to do it.

I have two worksheets
"Sheet1" and
"Sheet2" (for simplicity)

I want to compare column "I" (it will always be column "I") of both
worksheets (column I contains user ID's). If a user Id appears on "Sheet2"
and not "Sheet1" I want it to get highlighted.

Any ideas on how to get this accomplished would be greatly appreciated.