chaning colours if not entry is made

Hi again !!

This may be an awkward one (it is for me!!)

Is there a way to automaically change a cells colour if nothing has been put in it by the end of the day? for example if a cell is blank at 23:59 on the current date I would want the cell background colour to change to red. also could this be applied to the row or part of the row that the relevant cell is in?

Many thanks in advance for any help or advice you can give

Paul

Hi Many thanks for the reply

I cannot seem to find the window you used in your example I am using 2007 can you let me know where to find it or could i put some code on the sheet code bit As i would need this to reference all rows in the sheet?

Thanks again

Paul

Thanks Oldchippy I did have a look at it there but could not ffind anything like the window you showed in your exampl - somethings are better left as they are !!

Thanks again tho

Ahh excellent thanks that has helped to sort the coded bit out fine only problem is i actaually needed it to change the background colour of the cell (s) not the text colour - my fault for not explaining clearly in my original post sorry !!

any ideas?

Thanks again

Paul