How to Highlight Top or Bottom values in Excel
Step 1: Select the Cells where you want to Highlight Top and Bottom N items
To highlight the top and/or the bottom N items select the cells where you want to highlight top and bottom N items .
Step 2: Navigate to the Home tab and Click on the Conditional Formatting
Step 3: Choose Top/Bottom Cells
Click on the conditional formatting->Top/bottom cells->Top 10 Items. Choose a value in format cells that rank at the top and choose the format and click ok.
Step 4: Preview the Result
In the below figure, the red color indicates the top 5 values in rank.
Conditional Formatting in Excel
Excel Conditional Formatting is a handy feature that helps you visualize data and understand your spreadsheets better. Consider a worksheet that has tens of thousands of rows of data. Simply by looking at the raw data – patterns and trends would be very difficult to spot. By applying formatting rules to cells, anyone can spot patterns easily and changes in your data. With a range of preset formatting options and customization choices, conditional formatting provides flexibility as well as efficiency in analyzing and data presentation.
Contact Us