When pulling data from a data range in VLookup formula is it possible for the
formatting of that data to transfer as well? ie. the color and font size.
Can a macro be written to accomplish this function?

ANy help would be appreciated.