Excel EXPIRY DATE

[alliswell]

Hi everybody !

I have some products in column A and their expiry dates in column B. I want is, when it nears its expiry date a week before, the cell text should get changed to red. And when the day is equal to expiry date it should change the colour to light grey with strike through.

Thanks to all

 

[James006]

Hi,
In your conditional formatting rule, you can test following formula :

=B2>TODAY()-7