Show / Hide Information with Conditional Formatting Highlight
"I want a check box that appeared to mark a table with a sensitivity analysis of an income statement and that this check box off the table disappears (including borders) ".
We will use the following example:
We have a data entry for the price of a product and another entry for the amount. Below we have placed a checkbox with the text " see sensitivity analysis." To create this check box to we menu View / Toolbars / Forms and in the new toolbar that appears, click the above we checkbox:
The draw on the sheet, we set up drawn box and click on right mouse button. This opens a popup menu select the option that Format Control . A window opens and the tab Control in value select Without Activating and Link with cell we click in cell G2. press OK. From this moment each click the check box will become a TRUE or FALSE in cell G2.
What we get is what is shown in the following two pictures:
1. Select the range E3: F11 and draw the edges of the table.
2. In the range E3: E11 introduce prices that we assess the sensitivity analysis.
3. In cell F2 introduce the formula = C3 * C4
4. Select the range E2: F11 menu and go to Data / Table .
5. In the window that opens input cell column select cell C3 and click OK.
The result is as follows:
6. Hide the row 2 so you do not see the link formula or the result of the checkbox (true or false).
7. Select the range E3: F11 menu and go to Format / Conditional Formatting .
8. In Condition 1 select Formula and in the right box write the following = $ G $ 2 = FALSE
9. Format press the button and the tab Source we chose the font color white. In the Borders tab press the option None :
10. press OK and target achieved.