Скачать или смотреть The Magically Appearing Cell in Excel

Excel File: https://www.teachexcel.com/excel-tuto...
Excel Courses: https://www.teachexcel.com/premium-co...

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/o...
Hide Cell Contents (msft): https://support.microsoft.com/en-us/o...

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vba-course...
Building Professional Forms: https://www.teachexcel.com/premium-co...
Email Course: https://www.teachexcel.com/premium-co...

TeachExcel.com

#msexcel #howto #tutorial