Answered by:

How do expiration dates to show 30 days prior in Red in excel

Question

This may not be the question compatible with the forums topic, but unfortunately I couldn't find a specific forum for Microsoft Office 2007. Maybe someone completed such task before or knows how to accomplish it.

I am using Excel 2007.
Specific Example:

In one cell I input todays date - the date when the document is issued in the second cell I input the date when the document will expire.
My goal is to make the cell with date of expiration turn RED COLOR in 30 days before that date takes place in other words I should recognise expiration of the document by different color. So that I will be informed that the I should get on with the document
renewal in one month before the document expiration.

Answers

With todays date in cell A1 and the expiry date in cell B1, select cell B1 click on Conditonal Formating, select 'New Rule', then select the last option 'Use a formula to determine which cells to format', then where prompted type this formula =B1<=TODAY()+30,
click on 'Format', select the Fill tab, click on Red, then click 'OK' when prompted. Now when the date in B1 is 30days or less than the date in A1 it will be coloured red! Simple eh!

With todays date in cell A1 and the expiry date in cell B1, select cell B1 click on Conditonal Formating, select 'New Rule', then select the last option 'Use a formula to determine which cells to format', then where prompted type this formula =B1<=TODAY()+30,
click on 'Format', select the Fill tab, click on Red, then click 'OK' when prompted. Now when the date in B1 is 30days or less than the date in A1 it will be coloured red! Simple eh!

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.