Color cell based on two worksheets' matching values.

Closed
dan.2 Posts 1 Registration date Thursday May 25, 2017 Status Member Last seen May 25, 2017 - Updated on May 28, 2017 at 03:41 AM
vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - May 28, 2017 at 03:40 AM
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 response

vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
May 28, 2017 at 03:40 AM
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.
0