No problem, just try it and see it happen.

--
---
HTH

Bob


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



"Mike" wrote in message
...
Hello,

Is it possible to combine conditional formatting for cells which
correspond
to a Vlookup table or do I need to set the formatting separetly? For
example, I have a Vlookup table with cells containing "Yes" and No"
values.
If the answer is "No" I want the cell to be then formatted in Red and the
"Yes" cell in Green

Any help would be appreciated, thanks
--
Regards
Mike