{"id":396,"date":"2017-06-08T10:47:35","date_gmt":"2017-06-08T02:47:35","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=396"},"modified":"2017-06-08T10:56:49","modified_gmt":"2017-06-08T02:56:49","slug":"how-to-color-cells-that-contain-the-specified-content-in-excel-2010","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=396","title":{"rendered":"How to color cells that contain the specified content in Excel 2010"},"content":{"rendered":"

When we want to see the text of a specific content in Excel and display it, we need to color the cells that contain the specified content.
\n<\/span><\/p>\n

Step<\/strong>\uff1a<\/p>\n

For example: The information displayed in Excel in the figure, we need to find all the information of “<\/span>\u5317\u4eac\u5e02\u671d\u9633\u533a” and fill in the red.
\n<\/span><\/p>\n

\"\"<\/p>\n

    \n
  1. Choose the Conditional Formatting tool: Select this column of information and select conditional formatting-new rule in the toolbar.<\/span>\"\"<\/li>\n
  2. New formatting rule: In the dialog box for new formatting rules, select format only cells, edit the format under Edit Rule description, select specific text in the selection box,containing, in the Description box, enter “<\/span>\u5317\u4eac\u5e02\u671d\u9633\u533a<\/span>” and click “format”;<\/span>
    \n<\/span>\"\"<\/li>\n
  3. Format Cells: After the previous Steps, a pop-up box with format cells appears. Select Fill, click on the color red that we want to fill in the background color display below the fill, the example will appear red color bar, then click “OK”, the page returns to “new format rule” The Bullet box, click “OK”;<\/span>
    \n<\/span>\"\"
    \n<\/span>\"\"
    \n<\/span><\/li>\n
  4. After the completion of the above Steps, contains the contents of <\/span>\u5317\u4eac\u5e02\u671d\u9633\u533a<\/span> are filled with red<\/span>
    \n<\/span>\"\"
    \n<\/span><\/li>\n<\/ol>\n

    See you next week.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    When we want to see the text of a specific content in E … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-396","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2140,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=396"}],"version-history":[{"count":3,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/396\/revisions"}],"predecessor-version":[{"id":402,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/396\/revisions\/402"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}