LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Abi
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing conditional formatting when saving Eric FD Excel Discussion (Misc queries) 3 January 18th 05 11:42 PM
Formula Dependant Conditional Formatting LDanix Excel Discussion (Misc queries) 1 January 13th 05 06:50 PM
Copy conditional formatting across multiple rows? Gil Excel Discussion (Misc queries) 1 January 11th 05 11:27 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"