Hi, Good Morning.

I am trying to find a way to condition a group of cells so that if any date appears in a cell it changes to a colour (the colour initially is not important to me).

I have searched hard in the conditional format settings but the date functions are predefined to fill the cell if it has todays date, yesterdays, past 7 past month etc. I have tried to write a formula but have not been successful.

I am using 2007 but will need to be compatible with Excel 2003.

Any help or ideas are very much appreciated. Thanks.