# Highlight Important Excel Data With a Single Button Click

Author:

Using this method, you will be able to use checkboxes to control custom conditional formatting scenarios on your worksheet that will allow you to analyze your data much faster and more efficiently than before.

This allows you to quickly analyze your data to see which values stand out or need a closer look.

This tutorial shows you how to use a Checkbox to highlight important data within a Table, including entire rows or specific cells – including the Max or Min values, above average, below average, and any other mathematical formula that you'd like to see.

## Resources

Conditional Formatting

Highlight Data in Excel

Excel Function: AVERAGE(), MAX(), MIN()

#### Question? Ask it in our Excel Forum

##### Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

Similar Content on TeachExcel
Excel Workbook Reset with a Single Button Click [Easy Version]
Tutorial: How to easily clear or reset an entire workbook, specific worksheet, or just a few cells ...
Create PDF’s of Any Worksheet with a Single Button Click
Tutorial: How to quickly export the current worksheet as a PDF by clicking a single button. This al...
Reset a Worksheet with a Button Click
Tutorial: How to reset the values, formatting, and formulas for an entire worksheet with a single b...
Apply Conditional Formatting to Multiple Cells with a Single Formula
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in ...
Get Data from a ListBox Control
Tutorial: How to get data from a ListBox control and put it into a worksheet in Excel. Sections: Ge...
Join Parts of a List With a Single Formula in Excel - (1 Minute Tutorials)
Tutorial: How to quickly combine any part of an entire list of values into a single value in a sing...
Tutorial Details
Excel Function: AVERAGE(), MAX(), MIN()
##### Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)