Thanks HTH, In answer to your question, yes that's what I'm looking for, but I couldn't get it to work on my copy so I looked at how you did it and have cocked it up a bit (sheet 2 H11) I'm not sure what I've done but it won't work. I tried entering your formula into the conditional format and pulling it down from the others above, but failed, There are quite a few other headings and dates to go in the box so I would like to be able to understand what I've done wrong.
I don't know how you got rid of the '0' in column 'U' but thanks again for that.
My problems are still on sheet one with the 'Alert' flag still showing if there is no date in it, but what you have achieved in such a short time on sheet two is great I have upload the two sheets you have worked on to show you how I cocked it up(sorry) I have attached the cocked up version
Bookmarks