Color cell based on two worksheets' matching values.

Hello,

I am in the logistics field; one task that I have to do daily is compare two automatically populated workbooks (yesterday's and today's) and re-color orders from companies red, yellow, or green based on a ten digit order number. I'd love to build a macro to do that, but I don't know where to start.

For example, in column A of sheet 1 or workbook 1, the number in row 250 could be "1234567890" and the line will be colored green, yellow or red based on a previous decision. I'd like to be able to search for that number (1234567890) in a random row of column A on sheet 2 or workbook 2, and then color that line the same color as the cell/line in sheet 1 or workbook 1, leaving cells without matching numbers with no fill for me to manually color. I definitely don't mind copying and pasting the new workbook into the master workbook to make this work. Is this possible?

Thanks so much for any and all help!

Dan