Coloring borders in Calc not working

In Microsoft Excel, I made a calendar template for work.

I currently have the .xlsx file opened in Calc. All I want to do is recolor the borders. When I do so, it only colors zero, two, or three of the borders instead of all four.

I’m doing it by right click → format cells → borders; all I do is change the color and it does one of the three described above.

Am I doing something wrong? This shouldn’t be a hard thing to do.

I think you need to select:

Menu/Tools/Options/LibreOffice calc/View - Visual aids - Grid lines - Show on colored cells.

I have tried your suggestion. It still does the same thing.