Question

In the Annual Sales worksheet, use the Find & Select tool to find the cell in the open spreadsheet that contains Conditional Formating and apply a Thick Outside Border.

Answer 1

To find cells with Conditional Formatting and apply a thick outside border in an Excel spreadsheet, use the 'Find & Select' tool to select cells with conditional formats, then apply the border through the Font group under the Home tab.

Step-by-step explanation:

To find and apply thick outside borders to cells with Conditional Formatting in the Annual Sales worksheet using Microsoft Excel, you should follow these steps:

1. Open the Annual Sales worksheet in Excel.
2. Go to the Home tab on the Excel ribbon.
3. Click on the 'Find & Select' dropdown in the Editing group and choose 'Go To Special'.
4. In the Go To Special dialog box, select 'Conditional Formats' and then choose 'All' to select all cells with conditional formatting.
5. Click OK to highlight all the cells with conditional formatting.
6. With the cells selected, go back to the Home tab.
7. In the Font group, click on the border icon.
8. Select 'Thick Box Border' to apply a thick outside border around the selected cells.

By following these steps, you can efficiently find cells with conditional formatting and apply a thick outside border to those cells in the spreadsheet.