find numbers from one sheet on new sheet and highlight

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.

Use conditional formatting for this.

Please Login or Register  to view this content.

select a range of cells in column A starting at A2 and select home conditional formatting
selrct new rule

select the option "Use Formula"

Paste the above formula and then click on format and select red background.

Exactly what I was looking for thank you so very much, I doubt this will be my last inquiry for the day as I am working on a advanced data sheet.