I've got a spreadsheet that has multiple rows. It's setup so that the first row is a color and the second row is a different row. This pattern is then repeated every two rows. The issue I'm having is that sometimes I need to hide or delete a row. This causes the same two colors to repeat. Is there any way that I can create a formula (I'm guessing through conditional formatting) that will automatically change the color of a cell based on the color used in the row that is unhidden above it? Thanks in advance for any help.
Bookmarks