Display Row Borders When Text entered in Any Cell
 

I'm running Office Pro 2003.

Is there a way to turn on / display the borders of a row when text is
entered in any row cell?

Thanks much, Bill

Display Row Borders When Text entered in Any Cell
 

Hi,

You can use conditional formatting (Format/Conditional Formatting) with the
following formula:

=COUNTIF(1:1,"*")0

HTH
Jean-Guy


"Bilbert" wrote:

I'm running Office Pro 2003.

Is there a way to turn on / display the borders of a row when text is
entered in any row cell?

Thanks much, Bill

Display Row Borders When Text entered in Any Cell
 

Thanks Jean-Guy - However, the conditional formatting is actually turning the
borders on in the row below the row where the data was entered.

Tried hacking the formula some, with no success. Any suggetsions?

Thanks again, Bill

"pinmaster" wrote:

Hi,

You can use conditional formatting (Format/Conditional Formatting) with the
following formula:

=COUNTIF(1:1,"*")0

HTH
Jean-Guy


"Bilbert" wrote:

I'm running Office Pro 2003.

Is there a way to turn on / display the borders of a row when text is
entered in any row cell?

Thanks much, Bill

Display Row Borders When Text entered in Any Cell
 

Hi,

You need to adjust the row number to the first row in your selection. So if
the formatting starts on row 3 then =COUNTIF(3:3,"*")0

Cheers!
Jean-Guy

"Bilbert" wrote:

Thanks Jean-Guy - However, the conditional formatting is actually turning the
borders on in the row below the row where the data was entered.

Tried hacking the formula some, with no success. Any suggetsions?

Thanks again, Bill

"pinmaster" wrote:

Hi,

You can use conditional formatting (Format/Conditional Formatting) with the
following formula:

=COUNTIF(1:1,"*")0

HTH
Jean-Guy


"Bilbert" wrote:

I'm running Office Pro 2003.

Is there a way to turn on / display the borders of a row when text is
entered in any row cell?

Thanks much, Bill

Display Row Borders When Text entered in Any Cell
 

Conditional Formatting formulas are relative to the active cell
when you create the conditional formatting.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

so when you used 1:1 your active cell should be on row 1.
and the cells that are selected are subject to the formula
relative to the active cell.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"pinmaster" wrote in message ...
Hi,

You need to adjust the row number to the first row in your selection. So if
the formatting starts on row 3 then =COUNTIF(3:3,"*")0

Cheers!
Jean-Guy

"Bilbert" wrote:

Thanks Jean-Guy - However, the conditional formatting is actually turning the
borders on in the row below the row where the data was entered.

Tried hacking the formula some, with no success. Any suggetsions?

Thanks again, Bill

"pinmaster" wrote:

Hi,

You can use conditional formatting (Format/Conditional Formatting) with the
following formula:

=COUNTIF(1:1,"*")0

HTH
Jean-Guy


"Bilbert" wrote:

I'm running Office Pro 2003.

Is there a way to turn on / display the borders of a row when text is
entered in any row cell?

Thanks much, Bill