Hi ,
In "sheet1 Column A", I have a list of parts_ID's. In "sheet2 column A" I have a related list of part_ID's.
I need to format the cell in "sheet1 cell A2", so that if the same part-ID is not listed anywhere in "sheet2 Column A", then it should highlight red "sheet1 cell A2".
BTW, if relevent, I already named the range in "sheet2 column A" as "list"
Please provide me with exact code to copy and paste, with instructions where to apply the code.
Thank you very much, Nathaniel