Conditional Format Expiry Dates

**Paul Cooke** · 03-01-2010, 07:08 AM

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

**rwgrietveld** · 03-01-2010, 07:14 AM

Select all the cells you would like to have Cond. Formatting.

Assume F3 is your first

Add this to your conditional formatting: =F3>=Today(), set Fill color