VBA - Formatting range based on formula / rows count

[The Great SrH]

Hi guys,

I'm really struggling to code / piece together a code that factors in the situations I require. I'll piece it together below:

---------

The range:

.Range(K5:BM" & .Cells(.Rows.Count, "A").End(xlUp).Row)

I need it to apply the formula based on the last piece of information in column A - but the cells it will be applied to begin in K5 and end in column BM

---------

The formula:

=AND($E5>=K$2,$D5<L$2)

I need the changes to only happen based on the above formula. This was originally from a conditional format, however, I need this to be VBA as the sheet wont stay static.

---------

The changes:

With Selection.Borders(xlEdgeLeft)
        .LineStyle = xlContinuous
        .ThemeColor = 1
        .TintAndShade = -0.14996795556505
        .Weight = xlThin
    End With

    With Selection.Borders(xlEdgeRight)
        .LineStyle = xlContinuous
        .ThemeColor = 1
        .TintAndShade = -0.14996795556505
        .Weight = xlThin
    End With

    With Selection.Interior
        .Pattern = xlSolid
        .PatternThemeColor = xlThemeColorAccent1
        .Color = 5287936
        .TintAndShade = 0
        .PatternTintAndShade = 0.799951170384838
    End With

Any help piecing this together will be great!

Thanks

 

[The Great SrH]

Apologies - The formula is actually:
<l$5)[ QUOTE]
<l$5)[ CODE]

= AND ( $E5 > = K$2 , $D5 < L$2 )

(the code doesn't seem to work in CODE tags)

<l$2)<l$5)

Although im struggling to get this work as a conditional format now!</l$2)<l$5)
</l$5)[></l$5)[>