|Whilst this request seems simple, I have searched without success for the right answer.|
I am using Excel 2007 in which I am maintaining a database of Material Safety Data Sheets (MSDS). Each MSDS has an issue date with an expiry date five years later. I know how to add 5 years to the issue date, but I want to change the cell colour of each cell when the expiry date is reached.
Any help would be greatly appreciated