conditional formatting conflict?

[Guest]

I have a three column sheet. The first column pulls information from another
sheet. The the other two are going to be blank with underline where someone
will handwrite their initials.

Here's what I wanted to do.

Column A formula:
=IF('sheet1'!A1="","",'sheet1'!A1)

Column A conditional formatting:
Is Formula A2(of the second sheet)>0 or =(A2>0)
The format puts a border on the bottom part of the cell. (one line)

Column's B and C on sheet 2 follow the same kind of conditional formatting.
Basically, if column A contains information, place a bottom border in the
cell (thus creating a blank line). If it doesn't contain any information,
leave the cell blank.

My problem is, if I just apply the conditional formatting to B and C, it
works perfectly. But, when I apply my formula to column A, it puts all the
borders in, and there is NO information (other than formulas) in the A cell.

Conditional formatting is recognizing a formula as information in the cell,
but I don't want it to. What am I doing wrong?

 

[Bob Phillips]

Abi,

Try testing LEN(A1)>0 rather than A1=""

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Brilliant! Thanks! I think I'm finally getting the hang of it all!