Excel, how to copy conditional formats in sequential order 1,2,3
 

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

Excel, how to copy conditional formats in sequential order 1,2,3
 

Take a look at "The difference between relative and absolute references"
in XL Help.

One way:

=NOT($Z6="")

In article ,
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

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

Excel, how to copy conditional formats in sequential order 1,2,3
 

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

Excel, how to copy conditional formats in sequential order 1,2
 

Thanks


"vezerid" wrote:

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

Excel, how to copy conditional formats in sequential order 1,2
 

Thanks,
That worked

"JE McGimpsey" wrote:

Take a look at "The difference between relative and absolute references"
in XL Help.

One way:

=NOT($Z6="")

In article ,
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

Excel, how to copy conditional formats in sequential order 1,2
 

Thanks Mike that worked

"Mike H" wrote:

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