So I have 3 Sheets, Sheet 1 = "ODL In Door", Sheet 2 = "ODL On Hold", and Sheet 3 = " MS #'s". So basically I would like for a macro to look at column A in ODL In Door and match and numbers to column B in the MS #'s and highlight them Red in the MS #'s Sheet. Then do the same fpr ODL On Hold but change them yellow. I would upload a sample sheet but I am not allowed from work to upload a sheet. If anyone has any questions I will do my best to describe better what I need.