When a cell is filled or cleared cause an action in the same row as the changed cell

[JCMus]

Hi. I would like to cause the appearance of some cells to change based upon a cell in the same row being filled or cleared.
i.e.
1. If cell B9 is filled then put a border around cells AX9:BY9, fill those cells yellow and scroll column AX to the left of the screen (Col A:L are frozen). If B9 is cleared then undo the changes; no border, no fill, scroll screen back.
2. If cell B10 is filled or cleared repeat above actions for AX10:BY10.
3. Repeat down to row 1000 (B11, B12...B1000).

Much thanks!
JCMus

[Pichingualas]

Use this code:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    
    Dim val As String
    
    Application.ScreenUpdating = False
    
    If Target.Column = 2 And Target.Row >= 9 And Target.Row <= 1000 Then
        val = Target.Value
        If val <> "" Then
            With Range("AX" & CStr(Target.Row) & ":BY" & CStr(Target.Row))
                .Borders.LineStyle = xlContinuous
                .Interior.Color = 65535
            End With
            ActiveWindow.ScrollColumn = 50
        Else
            With Range("AX" & CStr(Target.Row) & ":BY" & CStr(Target.Row))
                .Borders.LineStyle = xlNone
                .Interior.Pattern = xlNone
            End With
            ActiveWindow.ScrollColumn = 13
        End If
    Else
        Exit Sub
    End If
End Sub

Paste it on the corresponding sheet tho, like in the example. Check it to see the working macro.

Example1.xlsm

[watersev]

hi JCMus, if scrolling can be omitted, you can use Conditional Format and do not use VB at all, check attachment, put anything in B2, check result in E2:M2, clear B2.