Changing Border formatting on another worksheet based off of values on active worksheet

[LukeFrost]

Hello all. First post so excuse the ignorance of formatting. I've searched what I feel would be relevant and haven't found anything conclusive.

I'm looking to have a non active worksheet change border formatting based off of cells on the active sheet.
This is what I have so far. I don't receive any errors but there is not change to the worksheet.

This code is in the object of sheet "Lineup"

If Not Intersect(Target, Range("R14:GO53")) Is Nothing Then
        If Range("P4").Value > 9 Then
            With Worksheets("Presentation").Range("P13:AG14")
                .Borders.LineStyle = xlContinuous
                .BorderAround Weight:=xlMedium
            End With
        ElseIf Range("P4").Value = 9 Then
            With Worksheets("Presentation").Range("P13:AE14")
                .Borders.LineStyle = xlContinuous
                .BorderAround Weight:=xlMedium
            End With
            With Worksheets("Presentation").Range("AF13:AG14")
                .Borders.LineStyle = xlNone
                .BorderAround Weight:=xlNone
        ElseIf Range("P4").Value = 8 Then
            With Worksheets("Presentation").Range("P13:AC14")
                .Borders.LineStyle = xlContinuous
                .BorderAround Weight:=xlMedium
            End With
            With Worksheets("Presentation").Range("AD13:AG14")
                .Borders.LineStyle = xlNone
                .BorderAround Weight:=xlNone
            End With
        End If
End If

 

[Fluff]

Duplicate to: Changing Border formatting on another worksheet based off of values on active worksheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.