Conditional Formatting - Frame cells with Outline Border

[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

 

[Domenic]

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!

 

[Sam via OfficeKB.com]

Hi Domenic,

Thank you very much. That worked Great!

Cheers,
Sam