My spreadsheet has multiple rows. Each row has a checkbox. If a checkbox is ticked, conditional formatting will highlight that row. I am curious to know if there's a way to apply the conditional format to the next 500 rows as if I'm just dragging down a formula which will reference the cells correctly.
I tried using the format painter, but all that does is extend the highlighted area if I were to tick a single checkbox. Conditional Format Rules Manager doesn't help my situation as the options are very limited. Copying and pasting just the formatting rules still just extends the highlight from a single row.