Unanswered: VBA/macro for conditional formatting a table that varies
I am trying to create a VBA macro within Excel that will apply a 3 scale conditional formatting to 3 different ranges within a "table" in Excel, see attached. Each of the 3 ranges (separated by the blue lines which are actually cells) will be a separate conditional formatting rule. The totals will not be part of the conditional formatting, but what is the challenge is that the columns will vary. So another report may only have anywhere from 2 to the max of 10 columns, not including the totals. There will always be a column of "totals" and rows of totals and there will always be 3 different areas to color that will always begin at b10.
How do I write the macro so that it chooses the first range of numbers (without coloring the totals or text)? The xldown, xlleft or xlright functions don't seem to work here.