Fill in Color within formulas

[Guest]

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]

Tom

Formulas cannot format cells...they can only return values.

Perhaps Format>Conditional Formatting will do the job after the fact.

Post back with specifics is more help is needed.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks Gord!!!

That worked perfect.

Tom

Tom

Formulas cannot format cells...they can only return values.

Perhaps Format>Conditional Formatting will do the job after the fact.

Post back with specifics is more help is needed.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Happy you're sorted out.

Thanks for the feedback.

Thanks Gord!!!

That worked perfect.

Tom

Gord Dibben MS Excel MVP