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

  • Thread starter Thread starter Bel
  • Start date Start date
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.
 
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)
 
Back
Top