You will see from the sample spreadsheet I have configured conditional alerts in column Q to highlight the cell when values match with those in column D. I would like to add an alert to the condition.
Fernando and Brian have effectively written a formula to accomplish this I would just like to have it applied to spreadsheet.
If you need information on how they accomplished it let me know.
One example included the formula, however Fernando's method seemed to work very well.
Please be mindful that the values in column D are stock prices and change virtually every second.
Private Sub Worksheet_Calculate()
Dim xCell As Range
Dim xLastRow As Long
Dim xValue As Variant
xLastRow = ActiveSheet.Range("A1").Sp
If xLastRow < 2 Then Exit Sub
For Each xCell In Range("O2:O" & xLastRow)
xValue = xCell.Value
If Not IsError(xValue) Then
If xValue <> "" And xValue < 0.0002 Then
Cells(1, 15).Interior.Color = 255
Cells(1, 15).Interior.Color = 65535