Application.Goto Range("J2")
Set xR = Range("J2:J1000")
xR.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=($D2="""")*($I2<>$J2)"
xR.FormatConditions(xR.FormatConditions.Count).SetFirstPriority
With xR.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
End With
xR.FormatConditions(1).StopIfTrue = False
End Sub
Sub DelFormatConditions()
Dim xR As Range
Application.Goto Range("J2")
Set xR = Range("J2:J1000")
n = xR.FormatConditions.Count
For i = n To 1 Step -1
xR.FormatConditions(i).Delete
Next
End Sub