Checkbox form control in Excel
How to use a checkbox form control in Excel as a toggle switch: Click on the developer tab in the ribbon of Office Excel 2007, select insert, click on the checkbox icon under the form controls and finally drag with the mouse in any cell on the worksheet to get a checkbox control. Tip: If you don't see the developer tab, click on the office 2007 button on the top left of your Excel window, select 'options...' and then click 'show developer tab in the ribbon' under 'top options for working with Excel'.
Now right-click on the checkbox area and in the format control window that pops up click inside the text box next to the 'cell link' and type the cell address, for example, $A$1 and under 'value' click the 'checked' optionbutton. Change the text next to the checkbox button from 'checkbox1' to an appropriate name of your choice like 'turn formatting off or on'. When you now click on the checkbox, you will observe 'TRUE' in the cell address and 'FALSE' when the checkbox is unchecked. Now select the data under 'salary' from b4 to b12 and then under the 'home' tab select 'condtional formatting', 'manage rules' and under the 'conditional formatting rules manager' window define a new rule as shown in the Excel traing video. Now when you check the checkbox button values greater than or equal to 10000 are formatted 'red' and double underlined. When you uncheck the checkbox the condtional formatting of the data is not active. This can be of great convenience when you have formatted large amounts of data in different colors to get different important information from your data but you now no longer wish to display the formatting. You can also use the checkbox toggle switch during a presentation to make your point!|
|