condition foormatting sets cell format according to the condition that you specify
Answers
When the user select Total Sales, a Currency Style is applied to the answer.
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.The same cell is taking on different formatting instructions based on the displayed answer.
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.The same cell is taking on different formatting instructions based on the displayed answer.On the Data tab we have a list of Apps and their associated Sales. We will build our mini-report on the Report tab.
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.The same cell is taking on different formatting instructions based on the displayed answer.On the Data tab we have a list of Apps and their associated Sales. We will build our mini-report on the Report tab.The first step is to create a Data Validation dropdown list for the user to select one of the two calculations (Sales vs. App count).
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.The same cell is taking on different formatting instructions based on the displayed answer.On the Data tab we have a list of Apps and their associated Sales. We will build our mini-report on the Report tab.The first step is to create a Data Validation dropdown list for the user to select one of the two calculations (Sales vs. App count).On the Report sheet, select a cell (ex: C4) and create a dropdown list by selecting Data (tab) – Data Tools (group) – Data Validation.
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.The same cell is taking on different formatting instructions based on the displayed answer.On the Data tab we have a list of Apps and their associated Sales. We will build our mini-report on the Report tab.The first step is to create a Data Validation dropdown list for the user to select one of the two calculations (Sales vs. App count).On the Report sheet, select a cell (ex: C4) and create a dropdown list by selecting Data (tab) – Data Tools (group) – Data Validation. Now we will build the dynamic number format in the cell directly below the Data Validation dropdown (ex: C5).
When the user select Total Sales, a Currency Style is applied to the answer.When the user selects Count of Apps, the Number Style is applied to the answer.The same cell is taking on different formatting instructions based on the displayed answer.On the Data tab we have a list of Apps and their associated Sales. We will build our mini-report on the Report tab.The first step is to create a Data Validation dropdown list for the user to select one of the two calculations (Sales vs. App count).On the Report sheet, select a cell (ex: C4) and create a dropdown list by selecting Data (tab) – Data Tools (group) – Data Validation. Now we will build the dynamic number format in the cell directly below the Data Validation dropdown (ex: C5).We don’t want to set the number format directly on the cell because the formatting will be applied to the cell regardless of the answer being displayed. Under normal conditions, the formatting of cell C5 can’t be influenced by the choice made in cell C4.