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