Thread: I'm losing it
View Single Post
  #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.