Formula with filtering expired Certificates needed
Hello everyone.
So we are a Laboratory who has to keep track about certificates for certain Analytics/Chemicals. The sheet looks like this:
Number | Group | Chemical | Certificate issued | Certificate expired
We usually also have older certificates listed. So it looks like this as an Example.
123 | Radioactive | Chemical X | 13.02.2024 | 13.02.2025
123| Radioactive | Chemical. | 13.03.2025 | 13.03.2026
123| Radioactive | Chemical | 13.04.2026 | 12.04.2027
Is there a way to mark the cell red if the newest Certificate is not up to date? While ignoring the older Certificate.
The Excel list is really really long and our inventory is quiet large. So it would be quiet easier to just scroll down and check for red cells instead of checking every chemical individually
Another important point. They are not sorted, so i.e. Row 1 is about chemical A
Row 2 is about chemical B
Row 10 is again about chemical A