How do I keep the font color with VLOOKUP?

's Computer Specifications

I reference data from another workbook but the font color will not transfer,
only the value. How can I get both?

's Computer Specifications

Simply...no. Functions only return values, although if the colours signify
criteria then look up conditional formatting in help

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS

"Joboozy" <(E-Mail Removed)> wrote in message
news:A44E0BE7-C0DB-4D3E-A8A6-(E-Mail Removed)...
>I reference data from another workbook but the font color will not
>transfer,
> only the value. How can I get both?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Format for font color using font color	Jim	Microsoft Excel Worksheet Functions	2	29th Aug 2009 11:54 AM
vlookup and bring the "font color" of the cell across?	ernie.recob	Microsoft Excel Worksheet Functions	1	17th Aug 2009 02:50 PM
Is it possible to run a vlookup on font color	=?Utf-8?B?bGVwaGVhZA==?=	Microsoft Excel Worksheet Functions	3	18th Dec 2004 07:25 PM
Re: Hard drive <font color="blue"><B>data</B></font&g t; <font color="blue"><B>recovery</B></fo nt> services?	halleyscomet@gmail.com	Storage Devices	0	7th Dec 2004 03:11 PM
VLOOKUP - CHANGING FONT COLOR WHEN CRITERA CHANGES	=?Utf-8?B?VGlsbGllIFJvc2U=?=	Microsoft Excel Worksheet Functions	3	17th Sep 2004 04:19 PM