Changing text in other cells

[Guest]

I'd like the text in one cell to change if the value
of another cell becomes negative. How can I get that to
happen?

 

[JulieD]

Hi

something along the lines of

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
If Target.Value < 0 Then
Range("b1").Value = "a1 is negative"
Else
Range("b1").Value = "a1 is positive"
End If
End If
End Sub

---
this needs to go in the sheet module of the sheet that you working on (right
mouse click on the sheet tab, choose view code & paste the code there)

Hope this helps
Cheers
JulieD

 

[Tom Ogilvy]

=if(A1<1,"A1 is negative","Non Negative Text")

 

[Debra Dalgleish]

In the cell where the text should appear, you can use an IF formula. For
example:

=IF(B2<0,"Value is negative","Value is positive")

 

[Tom Ogilvy]

Of course the 1 should be a zero

=if(A1<0,"A1 is negative","Non Negative Text")