[Solved] Non Moving Horizontal Lines

[NurdBurd]

I have a spreadsheet that contains a list of all the players that I play with on zyngagames.com. I have all the names grouped together by a line (border) every third player. At times I have to remove a player's name from the list. If that person's information is setting on a line I don't want to lose the line. The lines every third player are to remain where they are and not follow the player's data or be deleted. The solution has to be sort-proof because the data is alphabetically sorted.

I have asked this question before. I printed the solution and put it in a notebook which I can not find. I searched the forum using many variables but I did not find the answer. So I am asking you to provide an answer to my question: How can I make horizontal lines (borders) stationary?

Thank you.

[RusselB]

Your original query, and the response, are here

[Bill]

I have asked this question before. I printed the solution and put it in a notebook which I can not find. I searched the forum using many variables but I did not find the answer.

There is a link above to "View your posts" which will list your posts, most recent first. It's in the same line as the "Logout" link.

[Alex1]

Select the area, click Format>Conditional formatting, replace Cell value is by Formula is, enter
MOD(ROW();3)=0
Click New Style, on tab Organizer enter a name, on tab Borders select a line style and click the bottom row under User-defined.