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

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

Use this code:

Please Login or Register  to view this content.

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

Example1.xlsm

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.