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