Forum Discussion
Conditional Formatting for multiple range
I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns? A B C D E F G 1 value Percentages ...
Thank you for your reply, yes that can be done, but what i actually want is a single rule that could be applied once and it will automatically calculate for all future tables, as such conditional formatting manager would not be full with same rule being apply over and over again.
I tried using INDEX and MATCH function to force Range in LARGE function (=LARGE(INDEX(C3;MATCH("Percentage of Total";C3;0)):INDEX(C3;MATCH(100%;C3;0));2)) unfortunately it only recognised the first table.