Thread: Conditionally Formatting Cells based on Values in a Range (2007)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sreid64 sreid64 is offline
external usenet poster
  
Posts: 3
Default Conditionally Formatting Cells based on Values in a Range (2007)
Hi and thanks in advance.
I have 2 columns of Data, A & B. Column A is a Named Range. I would like
to lookup and format cells in cloumn B if the value in a cell exists in the
column A named range. I believe I need to used the vlookup formula in
conditional formatting but am unsure and do not know how/where to create the
formula.

Again - Thanks
Reply With QuoteReply With Quote