您要查找的是不是：
- You really cannot sort a column on the basis of a conditional format. 实际上不能根据条件格式对某列进行排序。
- Also, when copying the conditional format to the entire column, you could have selected just the cells that contained data before using the Paste Special command. 此外,将条件格式复制到整列中时,您可能只选择了其中包含使用“选择性粘贴”命令之前的数据的单元格。
- You can set up to three conditional formats for one control. 最多可以为一个控件设置三种条件格式。
- Support for Number formatting in conditional formatting. 在条件格式中支持数字格式。
- In the Delete Conditional Format dialog box, select the check box for each condition that you want to delete, and then click OK. 在“删除条件格式”对话框中,选中要删除的每个条件的复选框,然后单击“确定”。
- To add another conditional format for the control, click Add, and then follow the same procedure that you used for Condition 1. 要为控件添加另一种条件格式,请单击“添加”,然后执行“条件1”中所使用的相同过程。
- Specify criteria to determine when conditional formatting will be applied. 指定准则以决定何时应用条件格式。
- In my example, cell A1 contains a column heading (Invoice), so I will select cell A2, and then click Conditional Formatting on the Format menu. 在我的示例中,单元格A1包含的是列标题(发票),所以我将选中单元格A2,然后单击“格式”菜单上的“条件格式”。
- If you want to add another conditional format for this control or group of controls, click Add, and then follow the same procedure that you used for Condition 1. 要为此控件或控件组添加另一种条件格式,请单击“添加”,然后执行“条件1”中所使用的相同过程。
- After you select the data that you want to format, the Create button in the Conditional Formatting task pane becomes available. 选中要设置格式的数据之后,“条件格式”任务窗格中的“创建”按钮变为可用。
- In 12, the Number tab in the Format Cells dialog will be available in conditional formatting so you can set conditional formatting to be number formatting. 在12里面,设置条件格式时,单元格格式对话框中的“数字”标签已经变为可用,所以你可以在条件格式中设置数字格式。
- For Conditional Formatting you can set Font Style, Underline, Color, and Strikethrough. 条件格式可以包括字体样式、下划线、颜色和删除线。
- Because a Data View is a view of live data, you see the conditional formatting applied immediately in Design view. 由于数据视图是实时数据的视图,所以您会看到条件格式立即应用于数据视图。
- In the upper-right corner to show the Common Data View Tasks list, and then click Conditional Formatting. 来显示“常见数据视图任务”列表,然后单击“条件格式”。
- The book has been styled in a modern format. 该书已按照现代版式制作。
- Conditional formatting enables you to quickly and easily color-code your information based on parameters that you set. 通过条件格式,您可以基于所设置的参数快速而轻松地对信息进行颜色编码。
- The sample text in the preview box changes to show you how the conditional formatting will look. 预览框中的示例文本会更改以向您显示条件格式的效果。
- You can apply conditional formatting to a control on a form or report if its value meets specific criteria. 如果窗体或报表上的控件本身的值满足特定条件,则可以对该控件应用条件格式。
- You can have up to 65536 cells with conditional formatting, each cell comparing the current cell to 65535 other cells. 可对最多65536个单元格应用条件格式,其中每个单元格都将当前单元格与65535个其他单元格相比较。
- You can locate duplicates in a range of data by using conditional formatting and the COUNTIF function. 可通过使用条件格式和COUNTIF函数在一系列数据中查找重复数据。
