I can't get it to run no matter what values are in my cells... code looks
perfect to me... where should I paste it?

"Patrick Molloy" wrote:

assuming V5 gets data after I5, maybe you could use the worksheet's change
event...

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = Range("V5").Address Then
If Range("V5") < Range("I5") Then
Range("J5").Value = "STOP"
Range("J5").Interior.Color = vbRed
End If
End If
End Sub

or just add the if check to whatever code you're running to pull in the data

"John" wrote in message
...
I don't want the cell to change back if the value goes back above the set
value in I5... I want it to trigger and stay "STOP" so I don't want to use
a
formula

"Patrick Molloy" wrote:

J5: =IF(V5<I5,"STOP","")

and set conditional formatting when J5 value ="STOP"

"John" wrote in message
...
I have a sheet that updates from an external feed...

I want to change cell J5 to "STOP" and format it RED if cell V5 is
below
the
value found in I5

is there an 'on calculate' command?