Formulas "pull" data from one cell to another.

They cannot "push" data.

Also, a formula cannot return formatting like a background color without the
help of VBA and a user defined function.


Gord Dibben MS Excel MVP


On Mon, 18 Sep 2006 18:34:01 -0700, Stuck!
wrote:

Hi - I am trying to transfer a highlighted cell to another worksheet by use
of a formula; the cell will not always have data in it and more importantly
require just the highlight itself.