Originally Posted by Pecoflyer

Hi
you always will have to enter your expiry date somewhere.
Why not enter it in say D1 ( or whatever).
Your expiry date cell ( say A1) - Select it , go to conditional formatting and enter the following formula =A1=$D$1 and format as required.