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?