How do I keep the font color with VLOOKUP?
I reference data from another workbook but the font color will not transfer,
only the value. How can I get both? |
How do I keep the font color with VLOOKUP?
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 HIS "Joboozy" wrote in message ... I reference data from another workbook but the font color will not transfer, only the value. How can I get both? |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com