VLOOKUP in conditional format?
 

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

VLOOKUP in conditional format?
 

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.
--
HTH...

Jim Thomlinson


"Danni2004" wrote:

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