Conditional Formatting - Frame cells with Outline Border
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1

Conditional Formatting - Frame cells with Outline Border
 

Try the following...

1) Select C1

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=(C$2<"")*(C$2=0)*(ROWS(C$1:C1)<=C$1000)

4) Choose your formatting

5) Click Ok

6) Copy formatting to other cells using 'Format Painter' or 'Copy
Paste Special Formats'.

Hope this helps!

In article <620ea1241517a@uwe, "Sam" <u4102@uwe wrote:

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

Conditional Formatting - Frame cells with Outline Border
 

Hi Domenic,

Thank you very much. That worked Great!

Cheers,
Sam

Sam wrote:
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

--
Message posted via http://www.officekb.com