VLOOKUP in conditional format?

  • Thread starter Thread starter Danni2004
  • Start date Start date
D

Danni2004

I have to VLOOKUP a field in a table but I also want the format of that field
in the table too.

Is there a way to achieve this?

Thanks in advance!
Danni
 
The short answer is no... Formulas and functions return values. They can
neither read nor return formats.

The only exception that I can thing of in your case would be if the itme
being looked up is formatted via a conditional format. If so and the CF is
the same for all of the values being referenced then just replicating the CF
in the new cell will replicate the format.
 
Back
Top