Conditional Formatting - highlight overdue dates

Solved/Closed
TanyaRT Posts 5 Registration date Sunday 16 November 2014 Status Member Last seen 20 August 2015 - 16 Nov 2014 à 03:41
TanyaRT Posts 5 Registration date Sunday 16 November 2014 Status Member Last seen 20 August 2015 - 16 Nov 2014 à 16:21
I am a beginner with conditional formatting and researching the net for an answer has left me more confused than when I began!

I am working with Excel 2007.

I have list of 'next inspection dates' in a column of which the cell values result from a formula based on a date in an adjacent column (last inspection completed) + a specific number of days to determine when the next inspection is due.

I need to format the next inspection date cells to highlight the next inspection dates that are now overdue ie: dates prior to today's date.

Some of these cells have text 'TBC' as the adjacent cells dates are 'Pending'. The TBC cells must also be subject to the formatting for when the Pending status changes to an actual date.

Your assistance is appreciated.
Related:

2 responses

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
16 Nov 2014 à 11:25
TanyaRT, Good afternoon.

Take a look at this example I did for you.

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
TanyaRT Posts 5 Registration date Sunday 16 November 2014 Status Member Last seen 20 August 2015
16 Nov 2014 à 16:21
Thanks Mazzaropi - perfect! Seems so basic when you put it like that ; )