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? so for example all 3 tables in a worksheet, all tables had dif...
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.