ExcelBanter - Text color is lost when using cell reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text color is lost when using cell reference (https://www.excelbanter.com/excel-discussion-misc-queries/241145-text-color-lost-when-using-cell-reference.html)

jasakron

Text color is lost when using cell reference

I want to maintian the cell formating (color) of the cell I refer to using
cell reference. I'm not interested in conditional formatting.

Gord Dibben

Text color is lost when using cell reference

Formulas return values only.

Without CF you would have to use VBA

Gord Dibben MS Excel MVP

On Sun, 30 Aug 2009 07:48:02 -0700, jasakron
wrote:

I want to maintian the cell formating (color) of the cell I refer to using
cell reference. I'm not interested in conditional formatting.

All times are GMT +1. The time now is 02:49 PM.