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

please explain to me in steps....thank you