I'm losing it

G

Guest

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.
 
R

Ron Rosenfeld

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.
Click to expand...

No you haven't lost it :).

Here is one way:

Assume your two cells are A1 and B1.

In A1 put the formula: =IF(B1>0,"$","")

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
 
N

NCA

hi, assuming cell A1 is where you "$" is.
and B1 is where your value is..

try this in C1:

=IF(B1>0,A1&B1,"")
 
G

Guest

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(B1>0,A1&B1,"")


.
Click to expand...
 
G

Guest

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!
 
G

Guest

Ron,

One other thing, the cell you B1 that I'm putting the
conditional formatting in, is blank if d13 =) my formula
is=IF(D13>0,"$","". 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)
Click to expand...
Is there anything else?? Thank you again in advance.
 
R

Ron Rosenfeld

Ron,

One other thing, the cell you B1 that I'm putting the
conditional formatting in, is blank if d13 =) my formula
is=IF(D13>0,"$","". Therefore, the below part of your
formula doesn't get rid of the border
Click to expand...

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),B1>0)
2. =OR(B1="",B1=0)


--ron
 
Top