{"id":1657,"date":"2013-04-18T10:37:19","date_gmt":"2013-04-18T10:37:19","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1657"},"modified":"2023-12-30T23:26:52","modified_gmt":"2023-12-30T23:26:52","slug":"excel-2013-conditional-formatting-through-quick-analysis","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-2013-conditional-formatting-through-quick-analysis\/","title":{"rendered":"Excel 2013: Conditional Formatting through Quick Analysis"},"content":{"rendered":"<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/new-for-office-2013\/\"><img decoding=\"async\" class=\"alignleft size-full wp-image-1707\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/new-for-office-2013-e1366281054450.png\" alt=\"new feature for microsoft office 2013\" width=\"125\" height=\"125\" \/><\/a>If you\u2019ve got a lot of data, it\u2019s not always easy to spot trends and to easily analyse your figures. <a title=\"Use conditional formatting to analyse data in Excel\" href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/2012\/10\/use-conditional-formatting-to-analyse-data-in-excel\/\">Conditional Formatting<\/a> can instantly show you patterns in your data by highlighting cells that meet certain conditions. So for example you might want to flag up sales below a certain threshold in red, or bold\u00a0occurrences\u00a0of a certain word. This feature has been present in Excel for years, but in Excel 2013 there&#8217;s a faster way to get to visualise patterns.<\/p>\n<p>Excel 2013 has introduced Formatting through Quick Analysis. In the below example, Colour Scale Formatting is used to look for high and low spots and highlighting them as such.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/CF1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-1659\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/CF1.png\" alt=\"Colour Scale Formatting for Excel 2013\" width=\"550\" height=\"281\" \/><\/a><\/p>\n<p>How to: Highlight some Excel data in a table and look for the Quick Analysis tag to float over the bottom-right corner of your selection. Put your mouse over this icon to explore the options.<\/p>\n<p>Icon Set is another option available under Quick Analysis formatting. For example totals meeting a target display a green arrow or a red arrow if they don\u2019t.<\/p>\n<p>Suggested options not doing it for you? You can always create your own Conditional Formatting rules.<\/p>\n<p><em>How to: Conditional Formatting &gt; Manage Rules (to define the target criteria)<\/em><\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/CF.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-1658\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/CF.png\" alt=\"Conditional Formatting in Excel 2013\" width=\"328\" height=\"154\" \/><\/a><\/p>\n<p>For more tips and features on Excel 2013 and other versions, browse <strong><a title=\"Best STL Training Courses London\" href=\"\/excel-2010-intermediate.php\" target=\"_blank\" rel=\"noopener\">Excel courses online from Best STL<\/a><\/strong>, available London and UK wide.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you\u2019ve got a lot of data, it\u2019s not always easy to spot trends and to easily analyse your figures. Conditional Formatting can instantly show you patterns in your data by highlighting cells that meet certain conditions. So for example you might want to flag up sales below a certain threshold in red, or bold\u00a0occurrences\u00a0of [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[108,171,448,536],"class_list":["post-1657","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-conditional-formatting","tag-excel","tag-quick-analysis","tag-tips"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1657"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1657\/revisions"}],"predecessor-version":[{"id":6853,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1657\/revisions\/6853"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}