I work in a hotel in Room Service. What I need to do is create a spreadsheet that will track product in a room by expiration date. For example, a bottle of coke will expire on July 21, I'd like the spreadsheet to alert me that the bottle will expire in 14 days. This way I can get that bottle out to avoid any expired items in the room. It doesn't have to scream at me, it could simply change the information red to inform me. I know how to have the spreadsheet update the date daily but I don't know how to have another cell compare itself to the daily date. If anybody has any suggestions, I'll be glad to hear them.