| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RC format formulas
All,
At the risk of asking a dumb question - here goes: Can an RC formatted formula reference cells on other worksheets? If so, how? TIA, Bill |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RC format formulas
Write your formula any way you want (make sure it points to the other
worksheet). Then tools|Options|General tab and check R1C1 Reference style. You'll see the way it works. (Let excel do all that work for you!) bill wrote: All, At the risk of asking a dumb question - here goes: Can an RC formatted formula reference cells on other worksheets? If so, how? TIA, Bill -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RC format formulas
Great tip! Thanks
Bill Dave Peterson wrote: Write your formula any way you want (make sure it points to the other worksheet). Then tools|Options|General tab and check R1C1 Reference style. You'll see the way it works. (Let excel do all that work for you!) bill wrote: All, At the risk of asking a dumb question - here goes: Can an RC formatted formula reference cells on other worksheets? If so, how? TIA, Bill -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formulas & format | Excel Worksheet Functions | |||
| conditional format formulas | Excel Worksheet Functions | |||
| need help deciding which formulas/format to use | Excel Discussion (Misc queries) | |||
| Display Cond. Format Formulas | Excel Discussion (Misc queries) | |||
| Cond. Format Formulas | Excel Programming | |||
Hybrid Mode
