Excel203中,根据文字颜色来筛选或排序.docVIP

Excel2003中，根据文字颜色来筛选或排序 在Excel2003的日常操作中，偶尔要根据文字的颜色来筛选或排序。在Excel高一级的版本中，实现起来估计很简单，但是2003中，一般情况下要做宏定义才能完成。这里我教大家一个非常简单的办法，用“替换”命令一招搞定。 例如，把下面文档中标注为红颜色文字的行放一起，把标注为黑颜色文字的行放一起。 1，把A列选中，统一文字的格式。（这一步很关键） 上图中，A列文字的格式为宋体、10号。 2，把A列选中，再在A列前复制一列，如下图。 3，选中A列所有文字，然后选择编辑—替换—选项，点选上面的“格式”按钮，调出格式对话框，选择字体选项卡，字体选宋体，字号选10号，文字颜色选择红色，确定。 4，在“替换为”的文本框中输入“红色文字”，然后选择“全部替换”按钮。 5，此时，第一列也就是A列红色文字行的编号全部变成了“红色文字”四个字。 6，最后一步，根据A列进行排序，排序完成后，删除A列，这样就把红颜色的文字行和黑颜色的文字行完全分开了。 real, in each pen business lending Qian not for by pen query, led to mortgage failure of. (Vi) not in accordance with the relevant provisions of the Bank operation, failed to identify false documents, certificates, authorizations, warrants, etc. (VII) in the credit risk management system to provide false information, is not required by the guest rating credit management objective, impartial ratings of credit, resulting in credit decision-making errors. (H) the investigation report conclusions of false record, misleading statement or material omission, resulting in credit decision-making errors. (I) the orders, directives, orders, suggest that others not involved in the investigation business, issued by the investigators. (10) without the approval of authorities, after the first credit investigation, credit first and then record, counter-current process operations such as operation prior to approval. (11) article does not meet the risk management Department, Marketing Management Department to carry out supervision and inspection and due diligence evaluations or providing false information. (12) other violations result in credit business at substantial risk or significant potential risk behaviours. Sixth chapter supplementary articles article 28th of this approach by the Head Office of risk management Department is responsible for the interpretation and amendment. 29th spontaneous herein from the date of implementation. Qilu silver computer transmission of qilu Bank documents (2012), No. 289Qilu Bank person