I would like to use a vlookup function to pull cell shading as part of
the results. Is this possible? We have a database that uses colors to
signify status of accounts and would like this to pull into another
sheet that uses vlookup.

Thanks for any help.


--
waldersha
------------------------------------------------------------------------
waldersha's Profile: http://www.excelforum.com/member.php...o&userid=26460
View this thread: http://www.excelforum.com/showthread...hreadid=397277

VLOOKUP does not work with cell shading that I know of, but I would try a
combination of the vlookup fuction and conditional formatting. Or, you may
be able to just use conditional formatting, depending on the conditions.
Hope this helps!
Chad

"waldersha" wrote:


I would like to use a vlookup function to pull cell shading as part of
the results. Is this possible? We have a database that uses colors to
signify status of accounts and would like this to pull into another
sheet that uses vlookup.

Thanks for any help.


--
waldersha
------------------------------------------------------------------------
waldersha's Profile: http://www.excelforum.com/member.php...o&userid=26460
View this thread: http://www.excelforum.com/showthread...hreadid=397277

Maybe you could use conditional formatting to shade the cells?

Say that one of the values you return is "Past Due". You could color
that cell (or row) red, using conditional formatting.

Similarly, if a value you're returning is numeric, like, 120 (as in 120
days past due, or something), you could conditionally format the cells
based upon if that value is greater than or equal certain numbers.

Let me know if this is not what you're after.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=397277

That would work except we have 6 colors to work with. As far as I know,
you can only use 3 in conditional format?


--
waldersha
------------------------------------------------------------------------
waldersha's Profile: http://www.excelforum.com/member.php...o&userid=26460
View this thread: http://www.excelforum.com/showthread...hreadid=397277

I should probably explain more about what I am after. The database
houses customer name, address, etc. The other sheet that uses the
Vlookup is an invoice sheet. We use a customer number to pull in Name,
address. I would like to shade if the customer is past due. This is
already done in the database sheet. Not sure if this can even be
accomplished, but thought that since you can copy and paste formats
maybe????


--
waldersha
------------------------------------------------------------------------
waldersha's Profile: http://www.excelforum.com/member.php...o&userid=26460
View this thread: http://www.excelforum.com/showthread...hreadid=397277

Perhaps you could try some code with an if statement that if it meets a
certain condition, such as past due, then it pastes the format from another
cell?
-Chad

"waldersha" wrote:


I should probably explain more about what I am after. The database
houses customer name, address, etc. The other sheet that uses the
Vlookup is an invoice sheet. We use a customer number to pull in Name,
address. I would like to shade if the customer is past due. This is
already done in the database sheet. Not sure if this can even be
accomplished, but thought that since you can copy and paste formats
maybe????


--
waldersha
------------------------------------------------------------------------
waldersha's Profile: http://www.excelforum.com/member.php...o&userid=26460
View this thread: http://www.excelforum.com/showthread...hreadid=397277