Describe how to apply conditional formatting in a spreadsheet to highlight sales figures that are both above the monthly average AND represent a new personal best for an individual salesperson.

To apply conditional formatting in a spreadsheet to highlight sales figures that are both above the monthly average and represent a new personal best for an individual salesperson, follow these precise steps. This method uses custom formulas within the conditional formatting rules. First, understand the purpose of conditional formatting: it automatically applies formatting (like colors or fonts) to cells based on specified conditions or rules. When a cell's value meets the rule, the formatting is applied; otherwise, it is not. This process is dynamic, meaning if the data changes, the formatting updates automatically. Assume your sales data is organized in a spreadsheet with columns for 'Salesperson' (e.g., Column A), 'Date of Sale' (e.g., Column B), and 'Sales Amount' (e.g., Column C). We will apply the conditional formatting to the 'Sales Amount' column (Column C). Step 1: Define the target range for conditional formatting. Select all the cells in the 'Sales Amount' column that contain sales figures, for example, C2 to C100. The formulas will be written from the perspective of the first cell in your selected range, which is C2 in this example. Step 2: Construct the formula for the first condition: 'above the monthly average'. The monthly average is the arithmetic mean of all sales figures within a specific month or overall dataset, depending on what constitutes 'monthly' for your data. To calculate the average of all sales amounts in Column C (e.g., from C2 to C100), you use the AVERAGE function. The formula will be `C2 > AVERAGE($C$2:$C$100)`. Here, `C2` refers to the cu....