Thread
:
Bring in cell format
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Bring in cell format
A formula may only return a value, not a format. macro required.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"prender" wrote in message
...
If I write a formula in a cell such as "=VLOOKUP(F9,Vacation_initials,2)"
to
bring in the contents of a cell on another worksheet, is there a way to
also
bring along the formatting of that cell? In this case, I'm choosing from
a
range of 256 cells each of which has a different format.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett