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

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.


--
ChrisTMI
------------------------------------------------------------------------
ChrisTMI's Profile: http://www.excelforum.com/member.php...o&userid=10342
View this thread: http://www.excelforum.com/showthread...hreadid=481899

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.


--
ChrisTMI
------------------------------------------------------------------------
ChrisTMI's Profile: http://www.excelforum.com/member.php...o&userid=10342
View this thread: http://www.excelforum.com/showthread...hreadid=481899