Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect - how to ensure the formatting is transferred
Hi Guys especially JB
Thanks to your excellent, concise and informed direction my chess tournament spreadsheet for use by the pupils at the school I teach in, is in ready to rock. One hopefully last thing.. How do you ensure when indirect looks up a cell it transfers the formatting .. In this case the colour of the font .. Some kids can only play only certain days .. Thanks for yesterday's help and keep up the great support .. regards Pete Garner Dean Close School, Cheltenham, England |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect - how to ensure the formatting is transferred
Formulas return values to their calling cells.
They cannot return formatting. For that, you'd need to use an Event Macro instead of your formula. If you need help with that, post back with a description of what your formulae are trying to do... In article , Pete G wrote: Hi Guys especially JB Thanks to your excellent, concise and informed direction my chess tournament spreadsheet for use by the pupils at the school I teach in, is in ready to rock. One hopefully last thing.. How do you ensure when indirect looks up a cell it transfers the formatting .. In this case the colour of the font .. Some kids can only play only certain days .. Thanks for yesterday's help and keep up the great support .. regards Pete Garner Dean Close School, Cheltenham, England |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked out from transferred excel files | Excel Discussion (Misc queries) | |||
Conditional Formatting: Logical AND fails to work with INDIRECT(.. | Excel Worksheet Functions | |||
setting transferred text as constant | Excel Discussion (Misc queries) | |||
Excel files transferred to XP system | Excel Discussion (Misc queries) | |||
Can I have info on first tab transferred to subsequent tabs? | Excel Worksheet Functions |