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
Bookmarks