I am using the vlookup function to return a value however I also want to set
the shading of the cell depending on the value in the lookup table. Do you
know if it is possible to this using a function?

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Wayne" wrote in message
...
I am using the vlookup function to return a value however I also want to
set
the shading of the cell depending on the value in the lookup table. Do
you
know if it is possible to this using a function?

Thanks Bob, I've tried the conditional formatting which goes half way to
solving my problem however I have more than three conditions which I want to
check against. So I will have to try something else.

"Bob Phillips" wrote:

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Wayne" wrote in message
...
I am using the vlookup function to return a value however I also want to
set
the shading of the cell depending on the value in the lookup table. Do
you
know if it is possible to this using a function?

Bob has an add-in on his site he

http://www.xldynamic.com/source/xld.....Download.html

which will give you up to 30 CF conditions per cell.

Hope this helps.

Pete

On Mar 5, 10:31*am, Wayne wrote:
Thanks Bob, *I've tried the conditional formatting which goes half way to
solving my problem however I have more than three conditions which I want to
check against. So I will have to try something else.



"Bob Phillips" wrote:
Seehttp://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Wayne" wrote in message
...
I am using the vlookup function to return a value however I also want to
set
the shading of the cell depending on the value in the lookup table. *Do
you
know if it is possible to this using a function?- Hide quoted text -

- Show quoted text -