Expiry Date

[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

 

[bobhc]

Good day and welcome to the forum,.....select all the cells that you want the CF in and then apply your rules and CF

 

[Khalid NGO]

Hi,
As bob advised, you can use CF for your range, and also use an helper cell as target date, see the example:

Regards,

 

[splinter09]

hello khalid ....thanks for reply....But your example does not highlight the past days (expired dates) your example only expires the date im currently at

 

[Ajesh]

Updated @Khalid NGO's sheet to higlight all the date equal to or prior to Date specified in cell B2 (currently it is taking current date from function Today(). You can enter any date as expiry date.)

See enclosed.

Thanks

 

[Khalid NGO]

hello khalid ....thanks for reply....But your example does not highlight the past days (expired dates) your example only expires the date im currently at

Hi,
Just update the CF Formula as below, the same mentioned in Ajesh Sheet:
=A2<=$B$2

This will check the dates in A2:A22 are less than or equal to B2.