Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top cell in a list to match cells below of a certain value?
I need my header row (one cell) to match cells below of a certain value. I'm
currently working on a calendar and have used the conditional format "v" which fills in the cell blue for people on vacation (gantt chart). I need the first cell in that column (Business) to turn blue if any of the cells below it are filled in. Does Excel do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top cell in a list to match cells below of a certain value?
Select the cell to be blue, say A1, then FormatConditional FormattingFormula
is: =NOT(ISBLANK($A2:$A10)) FormatPattern to blue. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 08:16:02 -0700, NS421 wrote: I need my header row (one cell) to match cells below of a certain value. I'm currently working on a calendar and have used the conditional format "v" which fills in the cell blue for people on vacation (gantt chart). I need the first cell in that column (Business) to turn blue if any of the cells below it are filled in. Does Excel do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top cell in a list to match cells below of a certain value?
Unfortunately, I've already used the 'up to 3' conditional formats for other
places in the spreadsheet. Is there a way to do this same concept within the cell? "Gord Dibben" wrote: Select the cell to be blue, say A1, then FormatConditional FormattingFormula is: =NOT(ISBLANK($A2:$A10)) FormatPattern to blue. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 08:16:02 -0700, NS421 wrote: I need my header row (one cell) to match cells below of a certain value. I'm currently working on a calendar and have used the conditional format "v" which fills in the cell blue for people on vacation (gantt chart). I need the first cell in that column (Business) to turn blue if any of the cells below it are filled in. Does Excel do this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top cell in a list to match cells below of a certain value?
Okay, so I tried putting that information into the cell and it works but
comes back with 'TRUE', as it's supposed to. Is there a way to change the 'TRUE' to something else, like a symbol or another text object? "Gord Dibben" wrote: Select the cell to be blue, say A1, then FormatConditional FormattingFormula is: =NOT(ISBLANK($A2:$A10)) FormatPattern to blue. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 08:16:02 -0700, NS421 wrote: I need my header row (one cell) to match cells below of a certain value. I'm currently working on a calendar and have used the conditional format "v" which fills in the cell blue for people on vacation (gantt chart). I need the first cell in that column (Business) to turn blue if any of the cells below it are filled in. Does Excel do this? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top cell in a list to match cells below of a certain value?
Do not place the formula into the cell.
Place the formula into the dialog box at FormatCFFormula is: Gord On Fri, 28 Sep 2007 07:03:01 -0700, NS421 wrote: Okay, so I tried putting that information into the cell and it works but comes back with 'TRUE', as it's supposed to. Is there a way to change the 'TRUE' to something else, like a symbol or another text object? "Gord Dibben" wrote: Select the cell to be blue, say A1, then FormatConditional FormattingFormula is: =NOT(ISBLANK($A2:$A10)) FormatPattern to blue. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 08:16:02 -0700, NS421 wrote: I need my header row (one cell) to match cells below of a certain value. I'm currently working on a calendar and have used the conditional format "v" which fills in the cell blue for people on vacation (gantt chart). I need the first cell in that column (Business) to turn blue if any of the cells below it are filled in. Does Excel do this? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top cell in a list to match cells below of a certain value?
There are 3 conditions per cell, not 3 conditions per sheet.
You cannot write a formula in a cell to change the cell's color. Gord On Fri, 28 Sep 2007 06:57:02 -0700, NS421 wrote: Unfortunately, I've already used the 'up to 3' conditional formats for other places in the spreadsheet. Is there a way to do this same concept within the cell? "Gord Dibben" wrote: Select the cell to be blue, say A1, then FormatConditional FormattingFormula is: =NOT(ISBLANK($A2:$A10)) FormatPattern to blue. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 08:16:02 -0700, NS421 wrote: I need my header row (one cell) to match cells below of a certain value. I'm currently working on a calendar and have used the conditional format "v" which fills in the cell blue for people on vacation (gantt chart). I need the first cell in that column (Business) to turn blue if any of the cells below it are filled in. Does Excel do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match values and create a list in one cell | Excel Discussion (Misc queries) | |||
How can find match of one cell from a column of cells? | Excel Discussion (Misc queries) | |||
Format cell to match cells below in same column | Excel Discussion (Misc queries) | |||
match cell in array1 with all cells in array2 | Excel Worksheet Functions | |||
How do I match two cells and input a value in a different cell? | Excel Worksheet Functions |