{"id":9340,"date":"2019-10-31T07:37:51","date_gmt":"2019-10-31T05:37:51","guid":{"rendered":"http:\/\/www.officetodo.com\/public\/?p=9340"},"modified":"2019-10-31T07:37:53","modified_gmt":"2019-10-31T05:37:53","slug":"how-to-compare-values-visually-excel-2007","status":"publish","type":"post","link":"http:\/\/www.officetodo.com\/public\/how-to-compare-values-visually-excel-2007\/","title":{"rendered":"How to compare values visually? | Excel 2007"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Perhaps the\neasiest way is to enter the data bars inside the cells. To do this, select the\ncells you wish to be analyzed and go under Home tab into Style section. From\nthe row click on the first button called &#8220;Conditional Formatting&#8221;.\nFrom there click on &#8220;Data Bars&#8221; and apply the style of your liking.\nAnother option would be to add icons inside the cells representing the values\ncompared to other values in the selection. Again, go to the &#8220;Conditional\nFormatting&#8221; button and choose &#8220;Icon Sets&#8221; from the menu. This\nview offers more possibilities so hover over to see the preview and decide\nwhich suits you best.&nbsp; <\/p>\n\n\n\n<!--more-->\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to compare values visually? | Excel 2007\" width=\"625\" height=\"469\" src=\"https:\/\/www.youtube.com\/embed\/doSYYF-6MAo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Perhaps the easiest way is to enter the data bars inside the cells. To do this, select the cells you wish to be analyzed and go under Home tab into Style section. From the row click on the first button called &#8220;Conditional Formatting&#8221;. From there click on &#8220;Data Bars&#8221; and apply the style of your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3501],"tags":[3550,3509,3697],"class_list":["post-9340","post","type-post","status-publish","format-standard","hentry","category-excel-2007","tag-compare","tag-excel-2007","tag-values"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/comments?post=9340"}],"version-history":[{"count":1,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9340\/revisions"}],"predecessor-version":[{"id":9341,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/posts\/9340\/revisions\/9341"}],"wp:attachment":[{"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/media?parent=9340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/categories?post=9340"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.officetodo.com\/public\/wp-json\/wp\/v2\/tags?post=9340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}