How do you conditionally format cell using absolute values and relative cell references?

[xcelnovice101]

Below is my code which isn't formatting the cells it's suppossed to. It looks like it isn't doing anything. I think the issue might be with the highlighted section of my code, but when I go to "Manage" my rules for conditional formatting, excel references the appropriate cell under the "Applies to" section. I am using relative cell references for for the majority of the rest of the code and this section follows a section that selects the correct cell for this conditional format.

    Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=""ABS[COLOR=#ff0000]()[/COLOR]>.005"""
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 255
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False

 

[xcelnovice101]

The formula that works in excel is =ABS($O$101)>0.005 for range O101. The differences between this and my code that isn't working are the "" in front of ABS and the "" in front of the last " behind .005 as well as the explicit reference of the range. Is there a way of referencing the cell using relative cell referencing or is there a way I can create a variable where the code will input the appropriate range? Maybe something like Formula1:="=ABS(" & Rng & ").0.005" I'm just not sure how to set the Rng = to the appropriate cell range.