View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.