hi
remove the absolute references ie change absolute reference $M$5 to relative
reference M5. it should adjust now.

regards
FSt1

"tvh" wrote:

I have the first row of a spreadsheet 'Conditionally Formatted' just the way
I want it. Cells A1 through N1 are highlighted when I enter a date greater
than 01/01/2007 in the M5 cell. I entered '=$M$501/01/2007' for the
'Formula Is' window and it works fine for that row.
However, when I copy and 'paste special' (format) to subsequent rows, the
conditional formatting is not copied correctly, all of the subsequent
formulae still say '=$M$501/01/2007'.
I also checked that the ToolsOptionsCalculation is set to 'Automatic'.
What am I missing?