I cannot use conditional formatting because each of the three blocks already
has formulas in them. Plus I need to accomplish to actions with these code.

So I would like some assistance in developing the code to utilize the
Worksheet_Change event using VBA.

1. I am trying to apply a thick border to the left side of the column
running from row 5 through row 56 for any column when the value in row 3 of
that column equals 1.

Thanks Bill

2. The code would need to check row 3 starting with column C going right.
Example check C3, D3 E3€¦. When the code hits the last cell that does not
contain a value then I need to apply a thick border to the right side of the
column running from row 5 through row 56 for the ending row