conditional formatting overdue dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
In my excel sheet I have a column (M7:M25) of dates when reviews have taken
place. I want to format it so that the dates that are more than a year old
are highlighted.. Any ideas? Thanks in advance :)
 
Hi,

In cell type =IF((TODAY()-M7)>365, "Overdue", "Current"), and then press
ENTER.

Regards

Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com
 
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

conditional formatting overdue dates 1
Excel Excel due and overdue date colours 2
conditional formatting deadlines 1
macro for displaying conditional formatting 1
conditional formatting on date where today is > or = datevalue 3
Conditional formatting, coloring the whole row 2
How do I highlight a cell when a date is overdue? 2
conditional formatting 6

Back
Top