I appreciate all your help so much Thank you - however I still cant get the cell to change to grey if closed despite what the date is! I have included the xample below and also the conditional formtting I have done - Also if possible would like the whole row (5) to change colour. - If I open this spreadsheet in a later version of Excel and tick the box will it convert over when I re-open on this old versin of excel?
Bookmarks