I need some help with an Excel formula..... I have a workbook with two sheets in it. "Sheet 2" contains a list of part numbers in a range that I named "Parts". "Sheet 1" will have part numbers entered on a daily basis in a single column. What I need is a formula to enter in each cell of this daily entry column on Sheet 1 that will check to see if the part number I just entered is listed in the "Parts" range on Sheet 2 and trigger that cell to have, say a yellow background color to notify me if the result is true or leave as is if false. Any assistance will be appreciated! |