| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in Color within formulas
When doing an "AutoSum" is there a way to being forward the "Fill Color"
within the anchor cell? Any help would be greatly appreciated. Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill in Color within formulas
Tom
Formulas cannot format cells...they can only return values. Perhaps FormatConditional Formatting will do the job after the fact. Post back with specifics is more help is needed. Gord Dibben MS Excel MVP On Mon, 28 Aug 2006 13:40:02 -0700, Tom wrote: When doing an "AutoSum" is there a way to being forward the "Fill Color" within the anchor cell? Any help would be greatly appreciated. Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill in Color within formulas
Thanks Gord!!!
That worked perfect. Tom "Gord Dibben" wrote: Tom Formulas cannot format cells...they can only return values. Perhaps FormatConditional Formatting will do the job after the fact. Post back with specifics is more help is needed. Gord Dibben MS Excel MVP On Mon, 28 Aug 2006 13:40:02 -0700, Tom wrote: When doing an "AutoSum" is there a way to being forward the "Fill Color" within the anchor cell? Any help would be greatly appreciated. Tom |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill in Color within formulas
Happy you're sorted out.
Thanks for the feedback. On Mon, 28 Aug 2006 18:09:01 -0700, Tom wrote: Thanks Gord!!! That worked perfect. Tom "Gord Dibben" wrote: Tom Formulas cannot format cells...they can only return values. Perhaps FormatConditional Formatting will do the job after the fact. Post back with specifics is more help is needed. Gord Dibben MS Excel MVP On Mon, 28 Aug 2006 13:40:02 -0700, Tom wrote: When doing an "AutoSum" is there a way to being forward the "Fill Color" within the anchor cell? Any help would be greatly appreciated. Tom Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Excel won't fill formulas | Excel Worksheet Functions | |||
| Fill formulas down in macro | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
