Colour in Cells containing dates

B

bobby todd

I want to have a column on cells containing expiry dates that change colour the closer they become to their expiry date. So they would be red if say they have 30 day's to go before expir

Bobby
 
P

Paul

bobby todd said:
I want to have a column on cells containing expiry dates that change
Click to expand...
colour the closer they become to their expiry date. So they would be red if
say they have 30 day's to go before expiry
Bobby
Click to expand...

You need Conditional Formatting (Format menu) with a formula such as
=(A1<TODAY()+14)
 
Top