Excel Sheet Formatting - Very Thick Borders OR Columns as Section Dividers

Copper Contributor

OBJECTIVE: I'm looking for a way to format a sheet to appear as if there is a very thick border between sections of content - thicker than the thickest option found when going to (Format Cells > Borders > Line Styles). I've attached a general example for reference.

 

BACKGROUND: Since the line options found under Format Cells I have been adding a column between the content sections then make the width .5 or 1 and fill it black. This works for the appearance, but it's not an efficient option for documents because then I can't just select an entire row to change the rows color without impacting my section divider column. I have tried locking the cells, but then I still can't select an entire row and change the fill. (Since the lock won't allow it)

 

QUESTION #1: Is there a way to lock cells that allows me to select locked cells and unlocked cells, but when I change the fill it only changes the unlocked cells? 

 

QUESTION #2: Is there a way to set thicker line styles?

 

If there is another method that I'm not thinking of, please share! Any and all help is appreciated!

2 Replies
I think your workaround the thick border is neat!
with regards to conditional formatting of rows - you can do it with non-contiguous cells.
visit these sites:
https://answers.microsoft.com/en-us/msoffice/forum/all/link-conditional-formatting-of-non-contiguous...
https://trumpexcel.com/excel-conditional-formatting/
HTH

pls see attached file.

hope it helps.

thanks..