1. Click a cell in the range of an existing conditional formatting rule. 2. Click the Conditional Formatting button on the Home tab. 3. Select Manage Rules. The Conditional Formatting Rules Manager, where you can edit or delete existing rules, opens. The rules shown here only include those applied to your current selection. If you want to see all the conditional formatting rules used in the worksheet, click the Show formatting rules for list arrow and select This Worksheet.
確定! 回上一頁