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