Excel 2007 change colour of cell depending on

March 3, 2011 at 19:01:27
Specs: Windows XP
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


See More: Excel 2007 change colour of cell depending on

Report •

#1
March 3, 2011 at 20:37:46
Your post should be here for better help: http://www.computing.net/forum/offi...

Report •
Related Solutions


Ask Question