Retain font/cell color on lookup/copy

  • Thread starter Thread starter JPS
  • Start date Start date
J

JPS

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
 
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
 
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.
 
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).
 
Back
Top