{"id":294660,"date":"2021-07-08T17:24:11","date_gmt":"2021-07-08T14:24:11","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-highlight-blanks-or-errors-in-microsoft-excel\/"},"modified":"2021-07-08T17:24:11","modified_gmt":"2021-07-08T14:24:11","slug":"how-to-highlight-blanks-or-errors-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-highlight-blanks-or-errors-in-microsoft-excel\/","title":{"rendered":"#How to Highlight Blanks or Errors in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3e07d2d3a30\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3e07d2d3a30\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-highlight-blanks-or-errors-in-microsoft-excel\/#How_to_Automatically_Highlight_Blank_Cells_in_Excel\" >How to Automatically Highlight Blank Cells in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-highlight-blanks-or-errors-in-microsoft-excel\/#How_to_Automatically_Highlight_Errors_in_Excel\" >How to Automatically\u00a0Highlight Errors in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Highlight Blanks or Errors in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Spotting things in a spreadsheet can be much quicker when you use colors that jump off the screen. With conditional formatting in Microsoft Excel, you can make finding blank cells or formula errors easier.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Automatically_Highlight_Blank_Cells_in_Excel\"><\/span>How to Automatically Highlight Blank Cells in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you have a spreadsheet full of data that you expect to fill every cell, you can easily overlook cells that are left empty. And a lack of data can be just as detrimental as incorrect data. Here\u2019s how to see blank cells by using conditional formatting.<\/p>\n<p>Open the sheet and select the cells where you want to <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly the formatting. Head to the Home tab and click \u201cConditional Formatting\u201d in the Styles group of the Ribbon. Choose \u201cNew Rule.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733095\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/HomeConditionalFormattingNewRule-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Home tab, click Conditional Formatting and pick New Rule\" width=\"245\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the New Formatting Rule window that appears, pick \u201cFormat Only Cells That Contain\u201d under Select the Rule Type at the top.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733097\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/FormatCellsContain-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Format Cells That Contain\" width=\"650\" height=\"403\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>At the bottom, pick \u201cBlanks\u201d in the Format Only Cells With drop-down box. Then, click \u201cFormat\u201d to the right of the preview to select how to format the blank cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-733096 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/FormatCellsContainBlanks-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Blanks and click Format\" width=\"650\" height=\"403\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the Format Cells window, use the tabs at the top for Font, Border, and Fill to choose your formatting. Click \u201cOK.\u201d For our example, we\u2019ll use Fill to color our blank cells bright yellow.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733099\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/FormatCellsContainBlanksFill-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose your formatting\" width=\"650\" height=\"561\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll be back on the New Formatting Rule window, where you\u2019ll see a preview of the formatting for blank cells. If you\u2019re happy with it, click \u201cOK\u201d to apply the conditional formatting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733098\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/FormatCellsContainBlanksFillApply-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Confirm and click OK\" width=\"650\" height=\"403\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You should then see any empty cells in the range that you selected highlighted with the formatting that you picked.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733100\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/ConditionalFormattingBlankYellow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Conditional formatting for blank cells in Excel\" width=\"493\" height=\"191\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Automatically_Highlight_Errors_in_Excel\"><\/span>How to Automatically\u00a0Highlight Errors in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Even though Microsoft Excel does a decent job of shouting errors out to you, they might not be noticeable if you have a large sheet to scroll through. To make sure that you see the errors quickly, conditional formatting can save the day.<\/p>\n<p>You\u2019ll actually follow the same process that you used in the previous section to highlight blanks, but with one difference.<\/p>\n<p>Switch to the Home tab, click \u201cConditional Formatting,\u201d and then choose \u201cNew Rule.\u201d<\/p>\n<p>In the New Formatting Rule window, pick \u201cFormat Only Cells That Contain\u201d at the top. But this time, pick \u201cErrors\u201d in the Format Only Cells With drop-down box at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-733103 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/FormatCellsContainErrors-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Errors\" width=\"650\" height=\"402\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, click \u201cFormat\u201d to choose the formatting. For this example, adjust the Font options to make the cells with errors bold and red. Click \u201cOK\u201d after you pick the formatting and \u201cOK\u201d again to apply the rule.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733102\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/FormatCellsContainErrorsFontApply-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Confirm and click OK\" width=\"650\" height=\"402\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now, those errors pop off the screen!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-733101\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/06\/ConditionalFormattingErrorRed-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Conditional formatting for errors in Excel\" width=\"492\" height=\"189\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can use this type of formatting in Microsoft Excel to do many other things as well. Check out how to use conditional formatting to highlight a row based on content or how to\u00a0create a progress bar in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/733093\/how-to-highlight-blanks-or-errors-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Highlight Blanks or Errors in Microsoft Excel&#8221; Spotting things in a spreadsheet can be much quicker when you use colors that jump off the screen. With conditional formatting in Microsoft Excel, you can make finding blank cells or formula errors easier. How to Automatically Highlight Blank Cells in Excel When you have a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":294661,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-294660","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/294660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=294660"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/294660\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/294661"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=294660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=294660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=294660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}