Is it possible though to change all border colors without changing the border style? I have already tried selecting the line color and going through the cells with CTRL - but this does change the line styles and I have multiple styles I don't want to do from scratch.
You can change the
.colorindex property independently from other properties of the border objects, in VBA:
Sub bordercolor() With Selection.Borders .ColorIndex = 32 End With End Sub
This will only change the border color not the linestyle nor the width. Assign this macro to a key for convenience.
32 denotes a color index value, adjust to your liking. See this article for a description of the border collection if you want to change one specific border only (