I'm after a method of placing a bottom border (or line) across a
number or columns if a certain cell value is met.

For example, everytime I enter a "2100" in cell A100, I'd like to have
a bottom border span from that cell with "2100" across to column Z.

Can anyone help with a solution, either Conditional Formatting or with
a Macro?

Tks Kaye S

Kay

Select A100:Z100 either by mousing or entering in the Name Box.

FormatCFFormula is =$A1=2100

Format for a border and OK your way out.

Note: in CF, border styles are limited to a very few.

Maybe format the cells with a nice color instead?

Gord Dibben Excel MVP

On Fri, 19 Nov 2004 09:57:03 +1000, Kay wrote:

I'm after a method of placing a bottom border (or line) across a
number or columns if a certain cell value is met.

For example, everytime I enter a "2100" in cell A100, I'd like to have
a bottom border span from that cell with "2100" across to column Z.

Can anyone help with a solution, either Conditional Formatting or with
a Macro?

Tks Kaye S

Works great, thanks Gord!

On Thu, 18 Nov 2004 18:29:32 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Kay

Select A100:Z100 either by mousing or entering in the Name Box.

FormatCFFormula is =$A1=2100

Format for a border and OK your way out.

Note: in CF, border styles are limited to a very few.

Maybe format the cells with a nice color instead?

Gord Dibben Excel MVP

On Fri, 19 Nov 2004 09:57:03 +1000, Kay wrote:

I'm after a method of placing a bottom border (or line) across a
number or columns if a certain cell value is met.

For example, everytime I enter a "2100" in cell A100, I'd like to have
a bottom border span from that cell with "2100" across to column Z.

Can anyone help with a solution, either Conditional Formatting or with
a Macro?

Tks Kaye S