MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Vlookup and Cell Formatting


Posted by Spence Baker on February 12, 2001 11:28 AM

I have color coded the data portion of a table and would
like to bring the colors across as well during a VLOOKUP.
It would be a tremdous visual aide for the users.

Thanks in advance,

Spence Baker


Posted by Mark W. on February 12, 2001 12:13 PM

Add another column to your table with a value
that is indicative of the color (e.g., "red") and
have your VLOOKUP() function return that value too.
Then use conditional formatting to convert that
value into the color it represents.