| 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 |
| 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 | |||
Threaded Mode
