Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

Spreadsheet 5. On the Border tab, under Line, in the Style box, click the line style that we want to use for the border. 6. In the Colour box, select the colour that we want to use. 7. Under Border , click the border buttons to create the border that we want to use. 8. Click OK. 9. In the Style dialog box, under Style Includes, clear the check boxes for any formatting that we do not want to include in the cell style. 10. Click OK. 11. To apply the cell style, do the following: 12. Select the cells that we want to format with the custom cell border. 13. On the Home tab, in the Styles group, click Cell Styles. 14. Click the cell style that we want to apply. • Conditional Formatting Conditional formatting helps us for specific questions about data. We can apply conditional formatting to a cell range, a table, or a PivotTable report. There are important differences to understand when we use conditional formatting on a PivotTable report (Figure 2.52(k). • The benefits of conditional formatting (Figure 2.52m) To analyse data, we often ask ourselves some questions, such as: Where are the exceptions in a summary of data over the past five years? What is the trend in data over the past two years? Who is responsible for such results during this month? What is the overall age distribution of employees? Which products have greater than 10% revenue increases from year to year? Who are the highest performing and lowest performing students in the class? Figure 2.52(m) Conditional formatting helps to answer these questions by making it easy to highlight interesting cells or ranges of cells, emphasise unusual values, and visualise data by using data bars, colour scales, and icon sets. A conditional format changes the appearance of a cell range based on a condition (or criteria). If the condition is true, the cell range is formatted based on that condition; if the conditional is false, the cell 61 range is not formatted based on that condition. Reprint 2026-27