Hello all,
I am new to the site, but I have poked around a time or two on here. I have a problem that I can't seem to over come.
I am comparing a schedule to a production report and I would like to figure out a way of the production report to look at the schedule and cross off the items that have been completed. I attatched a sample similar to what I am working with, and below (Example.xlsx) is something towards the logic that I was looking at.
Ex.
If Product Number in column A of sheet 1 is equal to Product Number in column A of sheet 2
if true
then is the sum of product produced in sheet 1 pivottable 1 equal to or within + or - ten percent of the sum of product scheduled
if that statement is also true
then highlight said row in yellow.
Bookmarks