Expiry date in excel

[splinter09]

hello im new here.....i would like to make a cell named ''expiry date'' and when i enter a specific date the cell turns red when it reaches the date i want.

i managed to do it but i have to select each item by time and go to conditional formatting and set the date i want and i dont want to do that cause it takes time and hard

what i want is all i have to do is just type a date and when it reaches the date the call turns red



please help