Highlight expiry date

  • Thread starter Thread starter Karray
  • Start date Start date
K

Karray

Can anyone please tell me how to highlight a cell red when a date is within 6
months of expiry. (Excel 2003)
 
To highlight cell A1 with expiry date in it, use Conditional Formatting with
FORMULA IS and use the formula
=(A1-Today())<180
and choose the format you want

You can paint this format over other cells you want to highlight
 
Thanks for replying Sheeloo - I have tried this and it didn't work. Is it
meant to be ())?
 
Sheeloo my apologies - my date wasn't formatted as "date" - once I did this
your suggestion worked - thank you very much.
 
Yes...
=(A1-TODAY())<180

Pl. check that their are no quotes in the formula...
 
You must log in or register to reply here.

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

How to highlight cells if it passes a set date? 6
please suggest a formula 2
conditional Reminder 2
Highlight expiry date 2
Emailing formula results 1
Cond Format: Expiry Date Alert 4
textbox font colour 2
Access Microsoft Access Calculated Field - Expiry Date 0

Back
Top