Vlookup Function Cell shading

[waldersha]

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.

[Excel_Geek]

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.

[waldersha]

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]

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????

[Chad]

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

[Chad]

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