00:00i am constantly amazed by questions people ask like this one here where someone asks if i can
00:05dynamically mask cell content with asterisks like this want to learn this cool stuff let's go we
00:11start by inserting a checkbox to developer control from active x we're going to select checkbox and
00:16place your checkbox anywhere in your worksheet now right click our checkbox go select properties
00:21and caption we're going to change to high show salaries and link cell we're going to say b1
00:26after that we're going to close our checkbox property windows and disable design mode and
00:31basically test it as you can see in cell b1 it toggles within true and false now to master cell
00:37content with an asterisks you select the cells to hide and you go home style conditionally formatting
00:42new rule and use formula and the formula is equal to b1 select format and then select number tabs on
00:49the menu here you're going to select custom and enter the following custom formatting then click
00:54click on ok twice like this and then you're done
Comments