Colour in Cells containing dates

G

Guest

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
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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top