I have a water filtration company, and I want to create a spreadsheet with all customer records on it, that will notify me 6 months after their purchase so I can easily see when customers need new replacement filters. I think it could be done through conditional formatting i.e. turning a the cell with the customers records red when they need a new filter, but I'm not sure. Any help would be greatly appreciated

Thanks