Hi

I have a workbook where on sheet 1 there are 200 rows of the different projects we are working on. I have a column labeled "Project Complete Date" and multiple tasks below that. Now on sheet 2 I need a summary of these tasks complete dates only. I am looking for code that will look at sheet 1 and color the corresponding cell on sheet 2 if there is a date put into the cell under the task. I don't need the date on sheet 2 just to color the cell. Example: Sheet1!C12 has a date in the cell then Sheet2!C12 cell change color to yellow, if no date in Sheet1!C12 then Sheet2!C12 is to revert back to no fill.

Thanks

John