Excel, how to copy conditional formats in sequential order 1,2,3
Remove the $$ from the cell reference:
=NOT(Z6="")
HTH
Kostis Vezerides
On Jul 3, 2:30 pm, 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
|