I am thinking using the DCOUNT function, in a new column on sheet 1, and then conditional formating in that cell that would change the row colour. Im not sure how to create that formula though