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
|
|||
|
|||
I'm losing it
Hopefully, I'm not asking for the impossible. On my
worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is numbers which are imported from another workseet in the same workbook, and the border bottom is a line. Here is what I would like to do: If the second cell brings in a number greater than 0, I want the $ in the first cell and the number with the border line in the second cell AND if the second cell brings in 0, I want no $ in the first cell and no border line (no 0 either) in the second cell. Is this possible or have I finally lost it. Thanks for your help. |
#2
|
|||
|
|||
I'm losing it
On Wed, 16 Jun 2004 13:10:58 -0700,
wrote: Hopefully, I'm not asking for the impossible. On my worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is numbers which are imported from another workseet in the same workbook, and the border bottom is a line. Here is what I would like to do: If the second cell brings in a number greater than 0, I want the $ in the first cell and the number with the border line in the second cell AND if the second cell brings in 0, I want no $ in the first cell and no border line (no 0 either) in the second cell. Is this possible or have I finally lost it. Thanks for your help. No you haven't lost it :-). Here is one way: Assume your two cells are A1 and B1. In A1 put the formula: =IF(B10,"$","") In B1 use conditional formatting with two conditions: Format/Conditional Formatting Cell Value Is Greater Than 0 Format/Borders and choose the line border bottom Add Cell Value Is Equal 0 Format/Font and choose the font color the same as the background (white if you are using the default) --ron |
#3
|
|||
|
|||
I'm losing it
hi, assuming cell A1 is where you "$" is.
and B1 is where your value is.. try this in C1: =IF(B10,A1&B1,"") " wrote: Hopefully, I'm not asking for the impossible. On my worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is numbers which are imported from another workseet in the same workbook, and the border bottom is a line. Here is what I would like to do: If the second cell brings in a number greater than 0, I want the $ in the first cell and the number with the border line in the second cell AND if the second cell brings in 0, I want no $ in the first cell and no border line (no 0 either) in the second cell. Is this possible or have I finally lost it. Thanks for your help. |
#4
|
|||
|
|||
I'm losing it
Thanks so much, I'll give it a shot.
-----Original Message----- hi, assuming cell A1 is where you "$" is. and B1 is where your value is.. try this in C1: =IF(B10,A1&B1,"") " wrote: Hopefully, I'm not asking for the impossible. On my worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is numbers which are imported from another workseet in the same workbook, and the border bottom is a line. Here is what I would like to do: If the second cell brings in a number greater than 0, I want the $ in the first cell and the number with the border line in the second cell AND if the second cell brings in 0, I want no $ in the first cell and no border line (no 0 either) in the second cell. Is this possible or have I finally lost it. Thanks for your help. . |
#5
|
|||
|
|||
I'm losing it
Thank you for assuring me that I haven't lost it. I so
appreciate your help, you've been there for me numerous times and quite frankly, you're the best! -----Original Message----- On Wed, 16 Jun 2004 13:10:58 -0700, wrote: Hopefully, I'm not asking for the impossible. On my worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is numbers which are imported from another workseet in the same workbook, and the border bottom is a line. Here is what I would like to do: If the second cell brings in a number greater than 0, I want the $ in the first cell and the number with the border line in the second cell AND if the second cell brings in 0, I want no $ in the first cell and no border line (no 0 either) in the second cell. Is this possible or have I finally lost it. Thanks for your help. No you haven't lost it :-). Here is one way: Assume your two cells are A1 and B1. In A1 put the formula: =IF(B10,"$","") In B1 use conditional formatting with two conditions: Format/Conditional Formatting Cell Value Is Greater Than 0 Format/Borders and choose the line border bottom Add Cell Value Is Equal 0 Format/Font and choose the font color the same as the background (white if you are using the default) --ron . |
#6
|
|||
|
|||
I'm losing it
Ron,
One other thing, the cell you B1 that I'm putting the conditional formatting in, is blank if d13 =) my formula is=IF(D130,"$","". Therefore, the below part of your formula doesn't get rid of the border Add Cell Value Is Equal 0 Format/Font and choose the font color the same as the background (white if you are using the default) Is there anything else?? Thank you again in advance. -----Original Message----- On Wed, 16 Jun 2004 13:10:58 -0700, wrote: Hopefully, I'm not asking for the impossible. On my worksheet I have among other things, 2 cells. The first cell is simply a $; the second cell is numbers which are imported from another workseet in the same workbook, and the border bottom is a line. Here is what I would like to do: If the second cell brings in a number greater than 0, I want the $ in the first cell and the number with the border line in the second cell AND if the second cell brings in 0, I want no $ in the first cell and no border line (no 0 either) in the second cell. Is this possible or have I finally lost it. Thanks for your help. No you haven't lost it :-). Here is one way: Assume your two cells are A1 and B1. In A1 put the formula: =IF(B10,"$","") In B1 use conditional formatting with two conditions: Format/Conditional Formatting Cell Value Is Greater Than 0 Format/Borders and choose the line border bottom Add Cell Value Is Equal 0 Format/Font and choose the font color the same as the background (white if you are using the default) --ron . |
#7
|
|||
|
|||
I'm losing it
On Wed, 16 Jun 2004 13:44:59 -0700,
wrote: Ron, One other thing, the cell you B1 that I'm putting the conditional formatting in, is blank if d13 =) my formula is=IF(D130,"$","". Therefore, the below part of your formula doesn't get rid of the border Then I guess you must have a formula in B1, because if it were truly blank, it would evaluate to zero. What is the formula? If the formula leaves a null string in the cell, you could either have it leave a zero, or change the conditional formatting formulas to: 1. =AND(ISNUMBER(B1),B10) 2. =OR(B1="",B1=0) --ron |
#8
|
|||
|
|||
I'm losing it
Good Morning Ron,
Thank you so much, it works You are the best! -----Original Message----- On Wed, 16 Jun 2004 13:44:59 -0700, wrote: Ron, One other thing, the cell you B1 that I'm putting the conditional formatting in, is blank if d13 =) my formula is=IF(D130,"$","". Therefore, the below part of your formula doesn't get rid of the border Then I guess you must have a formula in B1, because if it were truly blank, it would evaluate to zero. What is the formula? If the formula leaves a null string in the cell, you could either have it leave a zero, or change the conditional formatting formulas to: 1. =AND(ISNUMBER(B1),B10) 2. =OR(B1="",B1=0) --ron . |
#9
|
|||
|
|||
I'm losing it
On Thu, 17 Jun 2004 06:15:32 -0700,
wrote: Good Morning Ron, Thank you so much, it works You are the best! You're welcome. Glad to help. --ron |
Thread Tools | |
Display Modes | |
|
|