conditional formatting
 

cell number does not increase when copied -
=$F$62 when copied down one row stays =$F$62 not =$F$63
how do I get the cell number to increase like other formulas do

conditional formatting
 

That is because you made the column and row absolute ($), remove the $ sign
from the row reference:

=$F62

HTH
JG



"charlie" wrote:

cell number does not increase when copied -
=$F$62 when copied down one row stays =$F$62 not =$F$63
how do I get the cell number to increase like other formulas do

conditional formatting
 

Hi,

Get rid of the "$" sign in front of the "62" in the formula (i.e., $F62 and
not $F$62)

Regards,
B. R. Ramachandran


"charlie" wrote:

cell number does not increase when copied -
=$F$62 when copied down one row stays =$F$62 not =$F$63
how do I get the cell number to increase like other formulas do

conditional formatting
 

Thanks for your help

"pinmaster" wrote:

That is because you made the column and row absolute ($), remove the $ sign
from the row reference:

=$F62

HTH
JG



"charlie" wrote:

cell number does not increase when copied -
=$F$62 when copied down one row stays =$F$62 not =$F$63
how do I get the cell number to increase like other formulas do

conditional formatting
 

Thanks for the help

"B. R.Ramachandran" wrote:

Hi,

Get rid of the "$" sign in front of the "62" in the formula (i.e., $F62 and
not $F$62)

Regards,
B. R. Ramachandran


"charlie" wrote:

cell number does not increase when copied -
=$F$62 when copied down one row stays =$F$62 not =$F$63
how do I get the cell number to increase like other formulas do