Hi Guys,

Could someone help on one this please. I have some columns

F
H
J
L
N
P

Ranged from rows 3 - 29

The cells have be formated as dates and contain expiry dates for medications that are sent out to locations.

Is there a way to format the cell so if the date has gone past the current date it turns a different colour?

Many thanks for any advice offered

Paul