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 =(A20)
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?

Abi,

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

--

HTH

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


"Abi" wrote in message
...
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 =(A20)
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?

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

"Bob Phillips" wrote:

Abi,

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

--

HTH

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


"Abi" wrote in message
...
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 =(A20)
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?