How to Highlight the date if it is within 3 months from now
 

I am working with a spreadsheet having to do with various training my staff
must have. Some of the certificates expire after a few years, and I wanted
to enter a function so that a cell is highlighted when it is within 3 months
from expiring, so that I will know to schedule a new training session. I
tried using the Conditional Formatting option, but wasn't sure what formula
to write. Help!

How to Highlight the date if it is within 3 months from now
 

HR gal

=A1<TODAY()+90

Assuming future date is in A1

To enter into the range of cells A1:A23, select the range then
FormatCFFormula is:

=$A1<TODAY()+90

Note the $ sign to anchor the collumn reference but allow the row reference to
increment from A1:A23


Gord Dibben Excel MVP

On Fri, 9 Dec 2005 14:09:02 -0800, HR gal
wrote:

I am working with a spreadsheet having to do with various training my staff
must have. Some of the certificates expire after a few years, and I wanted
to enter a function so that a cell is highlighted when it is within 3 months
from expiring, so that I will know to schedule a new training session. I
tried using the Conditional Formatting option, but wasn't sure what formula
to write. Help!

How to Highlight the date if it is within 3 months from now
 

Your formula in conditional formatting could be (where D2 is cell with the
date):
=IF(DATEDIF(TODAY()+1,D2,"m")<3,TRUE,FALSE)

This method, as opposed to adding 90 days will highlight anything that is
within 3 calendar months. If run today is Nov 25, it will highlight every
date from Nov 26 to Feb 25. The 90 day method will highlight up to Feb 23.



"HR gal" wrote:

I am working with a spreadsheet having to do with various training my staff
must have. Some of the certificates expire after a few years, and I wanted
to enter a function so that a cell is highlighted when it is within 3 months
from expiring, so that I will know to schedule a new training session. I
tried using the Conditional Formatting option, but wasn't sure what formula
to write. Help!