A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I'm losing it



 
 
Thread Tools Display Modes
  #1  
Old June 16th, 2004, 09:10 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 16th, 2004, 09:23 PM
Ron Rosenfeld
external usenet poster
 
Posts: n/a
Default 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  
Old June 16th, 2004, 09:24 PM
NCA
external usenet poster
 
Posts: n/a
Default 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  
Old June 16th, 2004, 09:32 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 16th, 2004, 09:34 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 16th, 2004, 09:44 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 17th, 2004, 02:46 AM
Ron Rosenfeld
external usenet poster
 
Posts: n/a
Default 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  
Old June 17th, 2004, 02:15 PM
external usenet poster
 
Posts: n/a
Default 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  
Old June 17th, 2004, 09:09 PM
Ron Rosenfeld
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.