Retain font/cell color on lookup/copy
 

I am using a lookup function to pull data from one spreadsheet to another and
I need to retain the font/cell color from the source spreadsheet to the new
cell on the target spreadsheet.

Doable?
JPS

Retain font/cell color on lookup/copy
 

If the font/cell colour in the source sheet is applied through
conditional formatting, then you could use the same settings to apply
to your cell with the lookup formula. If they are set manually,
though, then you will not be able to reproduce them in another sheet
using a formula - you would need some VBA code to do that.

Hope this helps.

Pete

On Jul 22, 3:44*pm, JPS wrote:
I am using a lookup function to pull data from one spreadsheet to another and
I need to retain the font/cell color from the source spreadsheet to the new
cell on the target spreadsheet.

Doable? *
JPS

Retain font/cell color on lookup/copy
 

Pete,
Thanks, Not the answer I was hoping for. Based on your answer I assume that
colors entered manually are lost in formula functions. For example,. if the
font in cell A1 is blue and in cell C1 I enter +A1, the value in cell C1 will
loose its color properties.
--
JPS


"Pete_UK" wrote:

If the font/cell colour in the source sheet is applied through
conditional formatting, then you could use the same settings to apply
to your cell with the lookup formula. If they are set manually,
though, then you will not be able to reproduce them in another sheet
using a formula - you would need some VBA code to do that.

Hope this helps.

Pete

On Jul 22, 3:44 pm, JPS wrote:
I am using a lookup function to pull data from one spreadsheet to another and
I need to retain the font/cell color from the source spreadsheet to the new
cell on the target spreadsheet.

Doable?
JPS

Retain font/cell color on lookup/copy
 

Exactly. Formulae return only values.

BTW - in XL, it's usual to use =A1

the '+' is usually a holdover from 1-2-3 and is superfluous in XL (i.e.,
the formula is entered as =+A1).


In article ,
JPS wrote:

Thanks, Not the answer I was hoping for. Based on your answer I assume that
colors entered manually are lost in formula functions. For example,. if the
font in cell A1 is blue and in cell C1 I enter +A1, the value in cell C1 will
loose its color properties.