Vlookup Function Cell shading

[waldersha]

I would like to use a vlookup function to pull cell shading as part o
the results. Is this possible? We have a database that uses colors t
signify status of accounts and would like this to pull into anothe
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 colo
that cell (or row) red, using conditional formatting.

Similarly, if a value you're returning is numeric, like, 120 (as in 12
days past due, or something), you could conditionally format the cell
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 databas
houses customer name, address, etc. The other sheet that uses th
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 i
already done in the database sheet. Not sure if this can even b
accomplished, but thought that since you can copy and paste format
maybe???

 

[Guest]

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

 

[Guest]

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