The Magically Appearing Cell in Excel
A fun way to make a cell's contents appear when a specific action occurs.
This works when a certain threshold has been met, when another cell or range of cells equals a certain value, and with any other custom criteria that you can think of, almost.
This trick combines a formula with conditional formatting and custom number formatting and does not use vba or macros at all.
Additional Resources
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: I'll show you how to make a drop down list menu in a cell in Excel. This allows you to ha...
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Macro: This Excel macro filters a selection of data in order to display only the bottom 10 items ...
Macro: Reverse cell contents with this free Excel UDF (user defined function). This will mir...
Macro: Remove all data validation from a cell in Excel with this free Excel macro. This is a grea...
Macro: Extract whole words from a cell or sentence in Excel with this UDF. This allows you to spe...
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.)