I would like to use the dates in a certain column of an inventory spreadsheet to determine if a product's warranty has expired. I would like to mark the row in one color if the expiration date has already passed, another color if the date is within 1 year of the current date, and leave other rows as is. Can someone please tell me how I can do that, if possible? Thank you.