The $ sign stops it changing so remove the dollar sign from in front of the
number and drag away.

Mike

"ShoDan" wrote:

here is the formula I am using =NOT($Z$5=")

how do I copy or drag the formula down and have it change to

=NOT($Z$6=") then copy or drag it to change in the rows following each other
to
=NOT($Z$7=")
=NOT($Z$8=") and so on