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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
Two Condition Vlookup 1
Excel Vlookup Help 0
vlookup formatting problem 1
Conditional Formatting with Calculated Blank 2
Sum Vlookup where there are blanks 1
"conditional format " Formula 2
Capturing Formatting with VLookup 1

Back
Top