If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting over a picture | Carl Rapson | Setting Up & Running Reports | 0 | December 27th, 2004 04:21 PM |
Too much conditional formatting? | LJpse | General Discussion | 1 | November 8th, 2004 01:50 AM |
Required Field Conditional | Katherine R | New Users | 2 | September 1st, 2004 05:52 AM |
Pivots and keeping conditional formatting | Jenn | General Discussion | 1 | August 11th, 2004 10:35 PM |
Copy Conditional Formatting | Bianca | Worksheet Functions | 2 | August 9th, 2004 01:47 PM |