| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Lookup Function based on Font Color | Excel Worksheet Functions | |||
| How do I get an exact copy from a lookup reference.(Font style) | Excel Discussion (Misc queries) | |||
| copy/paste want to retain cell coloration but lose the conditional formatting source data | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Hybrid Mode
