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

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

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

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