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!