looking for a formula to mark colour on expired medicines

[learning_grexcel]

Hi guys,
We got a stock of medicines. Basically, the data contains purchased date and expiry date of the medicines.
I'm looking for a formula that should automatically mark a color say "red" when the medicine is expired.
Say the expiry date is 11th April, the formula should automatically mark red colour on 11th on all the medicines which expires on 11th....

 

[mole999]

you could use conditional format

=ISBLANK(L2)*(K2<=TODAY()+14)

Applied to column K
This says if column L is empty (you obviously want to write destruction date or disposal date in here)
and the date is within the next 14 days then I used a green format, medication could be a three month expiry widow to get the opportunity to use them up

a second line this shows 7 days, although a month would be better in amber

=ISBLANK(L2)*(K2<=TODAY()+7)

and the third cf

=ISBLANK(L2)*(K2<=TODAY())

set in red, unless you have marked as disposed

 

[learning_grexcel]

Thank you but I cannot get you exactly.
I have expiry date in D column, how I can do this?

 

[mole999]

for effective medicine control, you should have a destruction, removed from stock date, as well as the expiry date

if you change the K to a D (mine was just an example), and have a column that that either states in words, or just a date when it was removed, then that would be the L column, just needs adjusting