Can VLookup pull text format from data

  • Thread starter Thread starter dza7
  • Start date Start date
D

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
 
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.
 
Back
Top