Expiration dates alert/notification

[7oya]

I have a 100 sheet workbook, each with dates.I did conditional formatting to highlight expired dates

I need a way to view the expiration dates for each sheet without having to click through the entire workbook.
Is there an email alert or notification that i could set up?
or have all the highlighted dates transferred to a single sheet.

[daffodil11]

You could copy them over pretty easily.

Let's make a new sheet called Summary. This will go through every sheet, check if it is named Summary.
If it is not it will check every cell from A1:Z500 for the color red. If it finds it, it will copy the cell into the next blank row in Summary.

Please Login or Register  to view this content.

[7oya]

I understand that this code will transfer the expired dates to the Summary sheet. But will it list which sheet it came from?

[daffodil11]

You didn't say that before.

Anything can happen that you want it to.

Please Login or Register  to view this content.