Forum Discussion

Laosi's avatar
Laosi
Copper Contributor
May 15, 2025

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?

 

so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100,00%" which is the sum of percentages in each tables.

Is there a way to do that?

Charting
excel
Formulas and Functions

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    May 22, 2025

    You can use Conditional Formatting in Excel to highlight the top 3 largest percentage values across multiple ranges (even if they belong to different tables with different row lengths).

     

    Attached is an example file where you will also find the formula.

    Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

Resources