Hi experts,

I have a vlookup formula that retrieves data from another worksheet, but the
source worksheet has conditional formatting. I'd like to have the lookup
data retain the conditional formatting. Is there any way to do this?

For example, I type in an account number and my lookup formula provides the
full account name. In the source data, though, some of those account names
are in bold italics if the account is in certain status. My formula is
returning the account name correctly but applies the formatting of the
current worksheet.