Formula to highlight missed completion dates

Hi,

I have created a formula to use at work, when one of our offices emails me with a maintenance problem I add it to the sheet and give it a 'promise by date' (when the work has to be completed by. I then have a column where i can input the date that i completed the work, but i want a formula that highlights the whole row if the job hasn't been completed before the 'promise by date'.

Also another small problem i am having... I have formatted some of the columns so that they are set to date (so i can sort in date order) but every time i add a date i have to highlight the whole column and go to date - text to column - next - next - dmy - finish... is there any easier way? so that it makes all dates that i input automatically format?

I have attached a section of the sheet for you to look at.

Any help is appreciated

Thanks for the help Alkey, but I only wanted the rows highlighted when they had gone passed the 'promise by date' and hadnt been completed...so they were therefore overdue

Pl see attached file.

Sorry still not what Im looking for... I'm not sure if im explaining myself well.


What i want to do is...

When i receive a job i will enter it on the sheet and put in a 'promise by date' - this is the date that the job must be completed by.

If when that date has passed I have not completed the 'date repaired' i want that row to highlight. (as it will mean ive missed the deadline and i am late completing the job)

I hope this makes sense

Originally Posted by Fotis1991

Try this.

Formula:

Please Login or Register  to view this content.

Perfect, thank you!