Color cell based on two worksheets' matching values. [Closed]

Report
Posts
1
Registration date
Thursday May 25, 2017
Status
Member
Last seen
May 25, 2017
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
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

1 reply

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
Hello Dan.2,

There appears to be some confusion here.

A workbook is a file which contains any number of worksheets so I'm assuming that you have one workbook with the two worksheets. Thus, in your explanation, do you mean that you have one workbook with two worksheets, one named "Yesterday" and one named "Today"?

Cheerio,
vcoolio.