Re: Easy one...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Right click the tab at the bottom of the work*** that you want to have this functionality, select View Code from the popup menu that appears and copy/paste the code into the code window that opened up.

--
Rick (MVP - Excel)


"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:926F3934-1444-434B-92BE-3629A2AC0FE2@xxxxxxxxxxxxxxxx
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 work***'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" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C542543D-CB96-45E7-83BD-AF60C611360A@xxxxxxxxxxxxxxxx
> 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" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:B2AEA0EA-3520-42CD-B77B-68E9A7F20F1C@xxxxxxxxxxxxxxxx
>> > I have a *** 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?
>>
>>

.

Quantcast