Conditionally Formatting Cells based on Values in a Range (2007)

  • Thread starter Thread starter sreid64
  • Start date Start date
S

sreid64

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
 
for cell B2:
Under Conditional format, change first box to "formula is", input:
=COUNTIF(A:A,B2)>0

Replace the A:A callout with name of range, if desired. Copy formatting to
other cells. (alternative, select all the cells you want to format, with B2
being the active cell, and then apply this formatting).
 
Thanks Luke! that seems to do it. A follow up novice question for you. How
do I correctly format the name of the range in the formula? If I do the
column reference (A:A), it works fine, but I have multiple columns to check.
The Range name is FIVE. I tried: =COUNTIF(FIVE,B2)>0 with no success.

Thanks
 
Nevermind, I figured it out.
Thanks Again!

sreid64 said:
Thanks Luke! that seems to do it. A follow up novice question for you. How
do I correctly format the name of the range in the formula? If I do the
column reference (A:A), it works fine, but I have multiple columns to check.
The Range name is FIVE. I tried: =COUNTIF(FIVE,B2)>0 with no success.

Thanks
Click to expand...
 
Back
Top