Highlightable Tables in Excel (EASY)
Make a highlightable table in Excel that shows colored cells without any text but that you can still use in formulas and functions to perform calculations.
This allows you to make a nice visual representation of a table of data without sacrificing your ability to use the results in calculations, sorts, and filters in the worksheet.
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
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: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...
Tutorial: How to highlight data in Excel based on the number you input into a cell and the comparis...
Tutorial: In this tutorial, you'll learn how to create Pivot Tables in Excel without the use of act...
Tutorial: Speed up your workday with these 5 great Table Tips for Excel! These tips make it easier ...
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.)