VLookup & Conditional Formatting together

[Mike]

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

 

[Bob Phillips]

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)

 

[Marcelo]

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:

 

[Pete_UK]

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

 

[Carim]

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