conditional formatting conflict?
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?
|