Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally Formatting Cells based on Values in a Range (2007)
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). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sreid64" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally Formatting Cells based on Values in a Range (200
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 "Luke M" wrote: 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). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sreid64" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally Formatting Cells based on Values in a Range (200
Nevermind, I figured it out.
Thanks Again! "sreid64" wrote: 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 "Luke M" wrote: 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). -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sreid64" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditionally formatting cells based on other cells | Excel Discussion (Misc queries) | |||
conditionally format cell in a range, based on value in other rang | Excel Worksheet Functions | |||
Conditional formatting based on the sum of two cells (Excel 2007) | Excel Discussion (Misc queries) | |||
Formatting the color of a range of cells based on the value of one cell | Excel Worksheet Functions | |||
Excel 2007 Display value based on values in another column range | Excel Worksheet Functions |