Can VLookup pull text format from data

[dza7]

Hello,

I have a few VLOOKUP formulas that are pulling comments from a
previous spreadsheet. The comments have different text colors that
I'd like to replicate on this new spreadsheet. As it stands now the
VLOOKUP only brings over the comments in plan text.

Is there any way to bring over the text color as well? Maybe with
conditional formatting?

Thanks,

Dza

 

[Dave Peterson]

Formulas bring back values -- not formatting.

If you're using conditional formatting at the source cell, then you could use
the same rules in the destination.

If you're not using conditional formatting at the source cell, then you could
assign the rules you want in the destination cell. But depending on the version
of excel you're using, you may not have enough rules for all the formatting you
want.