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 ...
As your "tables" are not consistent in size, the conditional formatting formula must dynamically determine which cells to include in the comparisons. It's a little more complicated than what you tried. See the attached workbook.