How do I highlight a cell when a date is overdue?

B

Bel

Hi,
I was wondering if anyone could help provide the formula required to
highlight a cell when a return date is overdue.
Column L is the date sent and column M is the date returned. I want to
highlight the cells in column L if the corresponding cell in column M is
still blank after 14 days.
Thanking you in advance
B.
 
S

Sheeloo

Use Conditional Formatting with FORMULA IS in Cell L1 and use the formula
=AND(M1="",(TODAY()-L1)>14)

and paste the format to other cells in Col L or you can select the whole
range before entering the formula (with L1 being the first cell in the range)
 

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

Excel Excel due and overdue date colours 2
If cell is blank automatically enter today's date in the same cell 21
conditional formatting date and blank cell 3
Help with a date formula 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
IF command with In Progress, Overdue, and Closed results? 3
Conditional Formatting 1
Highlighting overdue tasks 3

Top