T
tvh
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$5>01/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$5>01/01/2007'.
I also checked that the Tools>Options>Calculation is set to 'Automatic'.
What am I missing?
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$5>01/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$5>01/01/2007'.
I also checked that the Tools>Options>Calculation is set to 'Automatic'.
What am I missing?