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 |