I'm losing it

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
hi, assuming cell A1 is where you "$" is.
and B1 is where your value is..

try this in C1:

=IF(B1>0,A1&B1,"")
 
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...
 
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!
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Border formatting row of cells 22
VBA set thick borders around non empty cells in range 0
conditional formatting 1
How to offset cell value from thick border lines? 3
Borders Rotating 90 Degrees 1
Conditional formatting equal values 2007 2
Loose formatting when printing more than one sheet 1

Back
Top