Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting

Cell Value is equal to =G7, colour cell orange

Then as expected I8's format is =G8, I9's is =G9 etc.

But, if I select the I7:15 and I19:30 and apply the same formatting above, it does not work. I1's is GG65531.

My question is this: how can I apply this conditional formatting to non contiguous ranges? I have several ranges which need the same formatting applied.

share|improve this question
up vote 0 down vote accepted

You should apply the formatting to the first range and then use the format painter to apply it to other ranges

share|improve this answer

Not 100% sure and I can't test but I think if you apply the formatting to the first range and select the others and do a redo it will work.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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