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.