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?

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?

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?

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?

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?

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?