Click OK to return to the sheet. Figure F This conditional format will highlight the subtotaling rows. Currently, the data set contains no formulas in column C so there’s no formatting.

To retrieve data from the data source to Excel, insert the formula in a cell in the following format: =SQL.REQUEST (connection_string, output_ref, Driver_prompt, Query_text, col_names_logical) ...

Click Format Painter. Click Shift + Spacebar to copy the format from G51 to the entire row (Figure F). Figure F: Copy the format from a single cell to the entire row. Image: Susan Harkins/TechRepublic ...