Display Row Borders When Text entered in Any Cell

[Bilbert]

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

 

[pinmaster]

Hi,

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

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

HTH
Jean-Guy

 

[Bilbert]

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]

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

 

[David McRitchie]

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.