With out using Conditional Formatting, how can I check a cells value if it can fall within a range of +\-.002?
I have this code but it seems to have limitations. 

Range("F6").Select
Set Min1 = Range("D6")
Set Max1 = Range("D6")
a = WorksheetFunction.Min(Min1)
b = WorksheetFunction.Max(Max1)

With Range("D6")
    If a < "0" Then
        Range("F6").Value = a + "0.0020" '(Difference of)
        Else
            If b > "0.0020" Then
            Range("F6").Value = b - "0.0020" '(Difference of)
    End If
End If
If Range("D6").Value < "-0.0020" Then
        Range("F6").ClearContents
        Else
            If Range("D6").Value < "0.0020" Then
            Range("F6").ClearContents
    End If
    End If
End With
I am stumbling on how to check the cell to see if it complies to a +\-.002 scenario and if it does, clear the contents of another cell. The above code will clear the cell if the value is positive, but not negative.

All help is appreciated.