Cond Format: Expiry Date Alert

Does anyone know how to solve this one?

I have passport expiry dates and I would like to conditionally format them so that 6 months before the passport expires, the cell containing the expiry date changes red.

Thanks

use conditional formatting

"ChrisTMI" wrote:

>
> Does anyone know how to solve this one?
>
> I have passport expiry dates and I would like to conditionally format
> them so that 6 months before the passport expires, the cell containing
> the expiry date changes red.
>
> Thanks
>
>
> --
> ChrisTMI
> ------------------------------------------------------------------------
> ChrisTMI's Profile: http://www.excelforum.com/member.php...o&userid=10342
> View this thread: http://www.excelforum.com/showthread...hreadid=481899
>
>

Sorry, maybe my question wasn't clear.

I want to use conditional formatting but I need the formula to solve the expiry date problem.

Hi,

Select the range containing the passport expiry dates (e.g., A2:a501), and
use the following conditional formatting formula,

Formula Is =DATEDIF(TODAY(),$A2,"M")<6

and format the cells as you wish. This would format the cells where the
expiry dates are less than six months from the current day (e.g., on
11/03/2005, it would format the cells where the expiry dates are 05/02/2006
or earlier)

Regards,
B. R. Ramachandran

and select the format
"ChrisTMI" wrote:

>
> Sorry, maybe my question wasn't clear.
>
> I want to use conditional formatting but I need the formula to solve
> the expiry date problem.
>
>
> --
> ChrisTMI
> ------------------------------------------------------------------------
> ChrisTMI's Profile: http://www.excelforum.com/member.php...o&userid=10342
> View this thread: http://www.excelforum.com/showthread...hreadid=481899
>
>

Many thanks - perfect.