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.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post