Apache OpenOffice Community Forum

I am new to spreadsheets, and I'm loving it! I am designing my own budgeting spreadsheet. I have alternating rows of white and gray background color. Is there a way to anchor the colors in the rows, so that 1/3/5/7/9 etc will stay gray, and rows 2/4/6/8 stay white? Right now, if I need to delete a row of data and shift the rest of the data up, the colors no longer alternate correctly.

Hi, and welcome to the forum.

Papayajg5 wrote: ↑Tue Apr 04, 2023 6:31 pm Is there a way to anchor the colors in the rows, so that 1/3/5/7/9 etc will stay gray, and rows 2/4/6/8 stay white?

Use conditional formatting to mark the row colors as shown in this attachment.
Read about conditional formatting in Help → Index or in User Guides (PDF) or searching for topics about it in the Calc Forum. Use styles, not Format → Cells to apply formatting.

If you need any additional assistance attach a spreadsheet demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach. Explain how your attachment differs from your goal.

Papayajg5 wrote: ↑Tue Apr 04, 2023 6:31 pm Delete writing from cells without deleting background color

Edit → Delete Contents → uncheck Formats → OK

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

Prefect - thank you!