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?
|