Control declarations of conformity with a macro?

Question

Macros

Good afternoon!

I have a document in excel, where many different declarations of conformity are uploaded, and also each has an expiration date for this document. About 500 documents.
Since it is already becoming difficult to manually monitor their relevance, the idea arose to find a macro that, at my request, would check all document expiration dates and highlight those documents whose expiration date has already expired. That is, it highlighted documents whose end dates are less than today. Is it possible to write like this? Maybe someone has? I understand how macros work, but I can’t write my own from scratch yet.
Thanks in advance.

Answer 1

Use Excel's Conditional Formatting feature.
Select the column with dates, then: Main - Styles - Conditional Formatting - Rules for selecting cells - Less than..., specify today's date.
As a result, all dates less than the current one (overdue) will be highlighted.
In the future, the algorithm can be improved - put a link to the cell with the current date and do not need to drive in the current date every time.

Answer 2

Do you have 500 files, 500 sheets per file, or 500 lines per sheet?
If there are 500 files / sheets, then the easiest way is to make a macro that will run through the files, receive data and process it.
If there are 500 rows, then in the case of Excel, you can apply conditional formatting, as advised above, and if religion allows you to transfer everything to GoogleSheets, then using the FILTER () or QUERY () function, you can select the necessary data and display it in a separate sheet.