Hi Mike,

Select the range Format|Conditional Format|

Cell Value Is - Equal to - ="Yes"
Format the font or pattern as Green

Add

Cell Value Is - Equal to - ="No"
Format the font or pattern as Red

OK

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mike" escreveu:

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