transfer a highlighted cell to another worksheet using a formula
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. |
transfer a highlighted cell to another worksheet using a formula
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. |
All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com