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.

  • what's wrong with highlighting the 500 cells and adding a new rule? (same as the 1st rule). – Blaine Dec 13 '17 at 5:01
  1. If you have a row set up the way you want, you should be able to select it and drag/fill down.
  2. If you have a row or some other region/range set up the way you want, you can do “Conditional Formatting” → “Manage Rules” and change the “Applies to” range to the range you want to cover.
    “Conditional Formatting” → “Manage Rules”

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.