S
Sam
Hi All,
Can anyone provide a Conditional Formula that can frame with a Border Outline
varying amount of cells in different columns. So in column "C", I may want
the first six cells to be framed by a Border Outline (Row 1 to Row 6 in
column "C").
Sample Data Layout:
Row 2 Column "C" to "Z" holds Numeric Values. These Numeric Values are the
Criteria to say which columns will have cells framed by a Border Outline.
Row 3 to Row 800 Column "C" to "Z" holds Numeric Values (to be outlined by a
border)
Row 1000 Column "C" to "Z" holds Numeric Values. These Numeric Values say how
many cells in a column should have a Border Outline around them.
Scenario:
The Conditional Formula Criteria:- look at Row 2 and any column with a value
of 0 (zero) will have the Conditional Formatting of Border Outline applied.
The number of cells to be outlined in any column is provided by Row 1000
Columns "C" to "Z" accordingly.
Thanks
Sam
Can anyone provide a Conditional Formula that can frame with a Border Outline
varying amount of cells in different columns. So in column "C", I may want
the first six cells to be framed by a Border Outline (Row 1 to Row 6 in
column "C").
Sample Data Layout:
Row 2 Column "C" to "Z" holds Numeric Values. These Numeric Values are the
Criteria to say which columns will have cells framed by a Border Outline.
Row 3 to Row 800 Column "C" to "Z" holds Numeric Values (to be outlined by a
border)
Row 1000 Column "C" to "Z" holds Numeric Values. These Numeric Values say how
many cells in a column should have a Border Outline around them.
Scenario:
The Conditional Formula Criteria:- look at Row 2 and any column with a value
of 0 (zero) will have the Conditional Formatting of Border Outline applied.
The number of cells to be outlined in any column is provided by Row 1000
Columns "C" to "Z" accordingly.
Thanks
Sam