| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
