{"id":1174,"date":"2018-01-10T13:59:29","date_gmt":"2018-01-10T05:59:29","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=1174"},"modified":"2018-01-10T14:06:33","modified_gmt":"2018-01-10T06:06:33","slug":"the-excel-conditional-format-function-can-also-be-plotted","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=1174","title":{"rendered":"The Excel conditional format function can also be plotted"},"content":{"rendered":"<p><span style=\"font-family: \u5b8b\u4f53;\">Since the conditional formatting feature has been introduced in Excel, it&#8217;s easy to filter data by certain criteria. But have you ever thought that this function happens to be used to draw &#8230; How do you implement conditional formatting?<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \u5b8b\u4f53;\"><span style=\"font-size: 12pt;\">Step 1: Fill the 1%~100% in a 10&#215;10 area, and turn this area into a set area for conditional formatting, <\/span>$M$10<span style=\"font-size: 12pt;\"> is the original completion rate data.<\/span><br \/>\n<img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/011018_0559_TheExcelcon1.png\" alt=\"\" \/><br \/>\n<span style=\"font-size: 12pt;\">Step 2: Set conditional formatting for the locale in the first stage, select Format only for cells containing the following, and set the condition to less than or equal to =<\/span>$M$10<span style=\"font-size: 12pt;\">, and the corresponding format is the cell fill color and the text color.<br \/>\n<\/span><\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/011018_0559_TheExcelcon2.png\" alt=\"\" \/><span style=\"font-family: \u5b8b\u4f53;\"><br \/>\n<span style=\"font-size: 12pt;\">&#8220;OK&#8221; followed by the following graphic design:<br \/>\n<\/span><\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/011018_0559_TheExcelcon3.png\" alt=\"\" \/><span style=\"font-family: \u5b8b\u4f53;\"><br \/>\n<\/span><\/p>\n<p><span style=\"font-family: \u5b8b\u4f53;\"><span style=\"font-size: 12pt;\">Step 3: Make the necessary landscaping for this 10&#215;10 area, including adding borders, setting the fill color to the same color as the text. The following styles can be further obtained:<\/span><br \/>\n<img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/011018_0559_TheExcelcon4.png\" alt=\"\" \/><span style=\"font-size: 12pt;\"><br \/>\n<\/span><\/span><\/p>\n<p><span style=\"font-family: \u5b8b\u4f53;\"><span style=\"font-size: 12pt;\">Step 4: Add a text box and enter the formula &#8220;= <\/span>$M$10<span style=\"font-size: 12pt;\">&#8221; In the text box<br \/>\n<\/span><\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/011018_0559_TheExcelcon5.png\" alt=\"\" \/><span style=\"font-family: \u5b8b\u4f53;\"><br \/>\n<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1176\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/8.gif\" alt=\"\" width=\"926\" height=\"595\" \/><\/p>\n<p><span style=\"font-family: \u5b8b\u4f53;\"><span style=\"font-size: 12pt;\">In the end, you can use<\/span><br \/>\n<\/span><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2018\/01\/011018_0559_TheExcelcon6.jpg\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since the conditional formatting feature has been intro &#8230; <a title=\"The Excel conditional format function can also be plotted\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=1174\" aria-label=\"\u9605\u8bfb The Excel conditional format function can also be plotted\">\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-1174","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2130,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1174","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=1174"}],"version-history":[{"count":3,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1174\/revisions"}],"predecessor-version":[{"id":1178,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1174\/revisions\/1178"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}