Custom Threshold Highlighting Trick in Excel
How to highlight data in Excel based on the number you input into a cell and the comparison you want to make.
This allows you to quickly input a new number and comparison in cells in Excel and then highlight the data that meets that criteria.
This trick combines:
- Custom formulas in Excel.
- Conditional Formatting in Excel.
- Checkbox controls in Excel.
This is an easy trick to add to any workbook in Excel and I show you how to customize it for your needs.
Resources
Apply Conditional Formatting to Multiple Cells with a Single Formula
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.)
Tutorial: Make a highlightable table in Excel that shows colored cells without any text but that yo...
Tutorial: How to make a popup window in Excel that appears when a value reaches a certain level. Yo...
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
Tutorial: Quick and simple way to sort and order your data in a custom order using a custom set of ...
Tutorial: Part 1 - Regular Expression Match Formula in Excel (No VBA) Part 2 - Complete Excel Reg...
Tutorial: A simple way to find the next completely empty row in Excel using VBA/Macros, even if som...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)