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