Conditional Formatting - highlight overdue dates [Solved/Closed]

TanyaRT
Posts
7
Registration date
Sunday November 16, 2014
Last seen
August 20, 2015
- Nov 16, 2014 at 03:41 AM - Latest reply: TanyaRT
Posts
7
Registration date
Sunday November 16, 2014
Last seen
August 20, 2015
- Nov 16, 2014 at 04:21 PM
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.
See more 

2 replies

Best answer
Mazzaropi
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- Nov 16, 2014 at 11:25 AM
2
Thank you
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

Thank you, Mazzaropi 2

Something to say? Add comment

CCM has helped 1596 users this month

TanyaRT
Posts
7
Registration date
Sunday November 16, 2014
Last seen
August 20, 2015
- Nov 16, 2014 at 04:21 PM
0
Thank you
Thanks Mazzaropi - perfect! Seems so basic when you put it like that ; )