ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I highlight a cell when a date is overdue? (https://www.excelbanter.com/excel-discussion-misc-queries/224647-how-do-i-highlight-cell-when-date-overdue.html)

Bel

How do I highlight a cell when a date is overdue?
 
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.

Bel

How do I highlight a cell when a date is overdue?
 
Thankyou so much. It's doing just what I needed.

B.


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com