Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .