View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default VLookup & Conditional Formatting together

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