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