An expert compiled some code for me that is working very. It basically alerts me when a certain condition is met.
The code is as follows:
For Each xCell In Range("q2:q" & xLastRow)
xValue = xCell.Value
xValue2 = xCell.Offset(0, -13).Value
If Not IsError(xValue) And Not IsError(xValue2) Then
If xValue <> "" And xValue2 <> "" And Round(xValue, 2) = Round(xValue2, 2) Then
PlayTheSound "Windows XP Ringin.wav"
Cells(1, 17).Interior.Color = 255
Cells(1, 17).Interior.Color = 65535
As you can see the code is applied to column Q.
Can someone please show me how to apply the same code to column L
I tried it myself but failed.