View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
charlie
 
Posts: n/a
Default 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