Hi there,

I'm from the Netherlands and I will try to explain my problem as good as possible.
I have a couple of different workbooks (one workbook for each project, containing different tabs) in which I try to track deadlines. When a deadline has been reached the cells in the workbook will turn red.
Instead of opening all workbooks all the time to check for red cells I would like to make a new workbook in which all the rows that have a 'red date' are automatically shown.

Is this possible?

Thanks in advance.

Adz