Make sure that your formula use absolute column and relative row for the cell reference, like

=$Z2 < ....

and not

=$Z$2 < ....

--
HTH,
Bernie
MS Excel MVP


"Pammy" wrote in message
...
I have a spreadsheet and in col z if I add a date, I want the entire line to
change font color to blue, if nothing in cell remain black, the conditional
formatting is:
if formula = z##### font color to blue.
My question when I right mouse click on the handle in cell a##### and drag
down and choose formatt only - the font changes to blue for all the rows,
even when cell z#### is blank and should be black until something is typed in
that cell.

Can you copy the conditional formatting or do you have to set it up in each
cell?