200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hello everyone,
Hope you all are doing great.
I am looking for excel formula for whenever the cell value crosses the Target cell value, I get alert/ notified.
For Example, Let say, the current value is 100 in excel and the target value is 105.
Whenever the current value crosses the target value i.e. 105, i want to capture the same in excel or i want alert / notified for the same.
Attached excel sheet for your ready reference.
Can I request for help for the same.
Regards,
Sub NotificationEmail()
Dim OutApp As Object
Dim OutMail As Object
Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application") 'enter the name of your email app
If Range("C4").Value > Range("D4") Then
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = "Your.EmailAddress@Outlook.com" 'change to your address
.CC = ""
.Subject = "New High Volume"
.HTMLBody = "New High of" & Sheet1.Range("C4")
.Close
End With
End If
Set OutMail = Nothing
Set OutApp = Nothing
Application.ScreenUpdating = True
End Sub
Sunil,
In the discussion above (attempting to clarify your question), you request a "simple formula" (but I suspect that's not what you want). My guarded response is...
If day high volume (target) is in D4 and current volume in C4 (and updated by some process), use:
=IF(C4>D4,"New high volume=" & C4 & " (manually replace D4)","")My view is that (without VBA) the highs of a single cell like C4 can't be captured and D4 can't be updated automatically (since circular references would be created in a formula).