Currently, I am using excel for chemical inventory. I have a master list sheet and then I have all labs having their own sheets within the same workbook. I have the separate sheets linked to the master list. If a cell in one of the separate sheets is edited, it will update on the master list. I have a conditional formatting on the separate sheets for expiration dates to change color 30 and 90 days from today. I would like for this to link to the main sheet. Is there a way that this could happen. I am very new to using excel for more than very simple tasks.