{"id":1243,"date":"2015-05-19T11:50:43","date_gmt":"2015-05-19T09:50:43","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1243"},"modified":"2024-02-06T15:45:29","modified_gmt":"2024-02-06T14:45:29","slug":"conditional-format-a-cells-value","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditional-format-a-cells-value\/","title":{"rendered":"Conditional Format a Cell\u00b4s Value"},"content":{"rendered":"<p>A great way to highlight values within your data set, Excel Table or <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> is to use Conditional Formatting rules.<\/p>\n<p>Formatting cells that contain a specific criteria, for example,\u00a0<em>greater than X<\/em>\u00a0or\u00a0<em>less than X<\/em>, is a good way to visualize your results.<\/p>\n<p>When your criteria references a cell, then you can make this conditional format interactive.\u00a0 So as you manually change the referenced cell\u00b4s value, the conditional format gets updated and you can see the live results, as shown below&#8230;.<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/H250MtFll10?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Cond-Format-Cell-Value.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Cond-Format-Cell-Value.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Cond-Format-Cell-Value.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong>\u00a0<\/span>Select\u00a0a cell in your Pivot Table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6817\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-01.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"797\" height=\"458\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-01.jpg 797w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-01-300x172.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-01-768x441.jpg 768w\" sizes=\"(max-width: 797px) 100vw, 797px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>Go to\u00a0<em><strong>Home &gt; Conditional Formatting &gt; New Rule<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6818\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-02.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"904\" height=\"389\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-02.jpg 904w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-02-300x129.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-02-768x330.jpg 768w\" sizes=\"(max-width: 904px) 100vw, 904px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong>\u00a0<\/span>Set\u00a0<strong>Apply Rule\u00a0<\/strong>to the third option: All cells showing &#8220;Sum of SALES&#8221; values for &#8220;MONTH&#8221; and &#8220;YEAR&#8221;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6819\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-03.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"532\" height=\"509\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-03.jpg 532w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-03-300x287.jpg 300w\" sizes=\"(max-width: 532px) 100vw, 532px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong>\u00a0<\/span>Select\u00a0a rule type:\u00a0<strong>Format Only Cells That Contain<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6820\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-04.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"584\" height=\"457\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-04.jpg 584w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-04-300x235.jpg 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong>\u00a0<\/span>Edit the Rule Description. Go to\u00a0<em><strong>Cell Value &gt; Greater Than &gt; Select The Cell<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-05-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6825\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-05-1.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"508\" height=\"185\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-05-1.jpg 508w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-05-1-300x109.jpg 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6822\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-06.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"520\" height=\"254\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-06.jpg 520w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-06-300x147.jpg 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong>\u00a0<\/span>Select the cell format. Click\u00a0<strong>Format\u00a0<\/strong>and select a\u00a0<strong>color.\u00a0<\/strong>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6823\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-07.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"528\" height=\"508\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-07.jpg 528w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-07-300x289.jpg 300w\" sizes=\"(max-width: 528px) 100vw, 528px\" \/><\/a><\/p>\n<p>Try it out now! The highlight now happens dynamically when you update the value.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-08.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Conditional Format a Cell\u00b4s Value\"  class=\"alignnone size-full wp-image-6824\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-08.jpg\" alt=\"Conditional Format a Cell\u00b4s Value\" width=\"791\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-08.jpg 791w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-08-300x174.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/17-Highlight-08-768x446.jpg 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff; text-decoration: underline;\">HELPFUL RESOURCE:<\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"Adding Data Labels To An Excel Chart\"  class=\"alignnone wp-image-1017 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/11\/728x90.jpg\" alt=\"Adding Data Labels To An Excel Chart\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/11\/728x90.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/11\/728x90-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A great way to highlight values within your data set, Excel Table or Pivot Table is to use Conditional Formatting rules. Formatting cells that contain a specific criteria, for example,\u00a0greater than X\u00a0or\u00a0less than X, is a good way to visualize your results. When your criteria references a cell, then you can make this conditional format [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17586,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[35,72,6,4],"tags":[98,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1243"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1243"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1243\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17586"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}