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

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

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

You will need to set up conditional formatting separately from the
VLOOKUP formula - use Cell Value Is, then Yes, click on the Format
button, Patterns tab (background colour) then choose Green. Then OK
and Add and similar for "No".

Hope this helps.

Pete

On Dec 19, 11:46 am, Mike wrote:
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

Hi,

If I understand correctly, Vlookup() provides you with the answer ...
i.e. Yes or No ...
which does not interfere with conditional formatting as such ...

With your cursor on the cell to be formatted ...
Format
Conditional Formatting
Cell Value is
equal to
="Yes"
Format
Patterns
Green
and then add new condition for ="No" in red ...

HTH