The Magically Appearing Cell in Excel

Excel File: https://www.teachexcel.com/excel-tutorial/2452/the-magically-appearing-cell-in-excel?nav=yt
Excel Courses: https://www.teachexcel.com/premium-courses/?src=youtube_v__PS3Ftomvt8

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.

Other Resources:
Conditional Formatting in Excel (msft): https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
Hide Cell Contents (msft): https://support.microsoft.com/en-us/office/hide-or-display-cell-values-c94b3493-7762-4a53-8461-fb5cd9f05c33

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v__PS3Ftomvt8
- Email Course: https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v__PS3Ftomvt8

TeachExcel.com

#msexcel #howto #tutorial

Видео The Magically Appearing Cell in Excel канала TeachExcel