Notification of calibration date within excel

So hey guys, my work currently uses a rather poorly layed out excel sheet that's long overdue a refresh. We have to do bi-yearly and yearly calibrations on over 400 pipettes. We use an excel sheet that a previous technician made but we've noticed about 80 pipette's that have gone nearly 14 months without calibration as the sheet wasn't highlighting the pipette's that were approaching their deadline.

And so, I want to completely re do it. I'm pretty much new to excel but I have a vision and I wanted to see how realistic it is. My goal is to have each Lab have the pipette's within listed into two sections: the ones that require yearly calibration, and the ones that require bi-yearly calibrations. Then, I wanted to have it so that as the deadline for their calibration period approaches the 5 odd cells within the row for the pipette would be highlighted a bright red. I was thinking of having the row copied into a new sheet to show it easier but I've realised that's probably too much.

I think so far it's pretty reasonable as I know cell conditioning would allow me to do the highlight function with at least one cell in the row, but I just wanted to double check if that all sounds manageable (aside from the fact I'll have to do it 400 odd times listing the pipette's name, location, serial number, first calibration, next calibration date, and if the pipette is used for GMP purposes). I also wanted to see if anyone had a cool input possibly for a neat function or something, or for tips on how to best do this.

I'd really appreciate any help as I love a good excel sheet but am kind of new to all of this. Thanks!