Quote ="getdownmonkeyman"Any Excel wizzes aout there? Basic, but infuriating, I have conditional formatting to change a cell coulour if a date is past. Unfortunately, if no date is entered the cell automatically infills itself.'"
I can tell you how I've done it when I wanted to use conditional formatting to highlight dates that fell before a specific date - may or may not be useful to you.
I had a load of dates in a column and wanted to highlight those dates prior to 20/12/2010. If you use a 'less than' rule it will also highlight those cells which do not have dates in them. I got around this by using a 'between' rule (i.e. between 1 and 40532). In this case the cell has to have a value in it to be highlighted (>1) and less than 40532 (the value for 20/12/2010).
You should be able to use one or more of the built-in date functions to set the limits for the conditional formatting values.
