ExcelBanter - conditional formatting overdue dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting overdue dates (https://www.excelbanter.com/excel-discussion-misc-queries/12037-conditional-formatting-overdue-dates.html)

Joooooooo

conditional formatting overdue dates

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 :)

Akhilesh Dalia

Hi,

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

Regards

Akhilesh Dalia
akhileshdalia<athotmail<dotcom

"Joooooooo" wrote:

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 :)

All times are GMT +1. The time now is 12:01 AM.