Hi all,
I've spent a long time searching for an answer to my query but nothing has seemed to work for me.
Here is my dilemma;
I have a spreadsheet for tracking shooting records for my cadets squadron, and there are Weapons Handling Tests which expire every 6 months from the date cadets pass it which is entered in the spreadsheet. I've managed to get a warning for a month away and a week away, but there is no way that I can find to tell me if they are already out of date after 6 months or longer. Ideally I'd want a red fill when 6 months or longer has passed.
I'm new to this sort of formatting and I might end up needing it "dumbed" down quite a bit. I'm using Excel 2010 FYI.
Thanks in advance!
Bookmarks