conditional formatting

C

charlie

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
 
P

pinmaster

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

=$F62

HTH
JG
 
B

B. R.Ramachandran

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
 
C

charlie

Thanks for the help

B. R.Ramachandran said:
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
Click to expand...
 
Top