{"id":4260,"date":"2021-05-20T00:02:00","date_gmt":"2021-05-20T04:02:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4260"},"modified":"2021-07-17T20:49:36","modified_gmt":"2021-07-18T00:49:36","slug":"make-excel-check-boxes-look-better-with-formatting-tricks","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2021\/05\/20\/make-excel-check-boxes-look-better-with-formatting-tricks\/","title":{"rendered":"Make Excel Check Boxes Look Better with Formatting Tricks"},"content":{"rendered":"<p>Do you ever use check boxes on your Excel worksheets? They&#8217;re handy for choosing options, or marking completed items in a To Do list.<\/p>\n<p><!--more--><\/p>\n<h3>Video: Enhanced Excel Check Boxes<\/h3>\n<p>In this video, Jon Acampora, from Excel Campus, shows&nbsp; a few tricks for making those check boxes look better.<\/p>\n<p>You&#8217;ll see how to use conditional formatting with those check boxes, to change completed items to grey text, or to cross them out.<\/p>\n<p>To follow along with Jon&#8217;s video, <a href=\"https:\/\/www.excelcampus.com\/tips\/checkbox-conditional-formatting\" target=\"_blank\" rel=\"noopener\">go to his website and download the sample file<\/a>.<\/p>\n<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/b2CNYHTVgiY\" allowfullscreen=\"allowfullscreen\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n<h3>Form Control Check Boxes<\/h3>\n<p>In the video, Jon uses Form Control check boxes. Those work on Windows and Mac systems, so they&#8217;re a good choice if you&#8217;re sharing your workbook with other people.<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2021\/05\/orderformcheckbox01.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"check box from form controls\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2021\/05\/orderformcheckbox01_thumb.png\" alt=\"check box from form controls\" width=\"281\" height=\"215\" border=\"0\"><\/a><\/p>\n<h3>More Excel Check Box and Format Tips<\/h3>\n<p>Here are a few more Excel check box and formatting tips, on my Contextures website and blog.<\/p>\n<p><a href=\"https:\/\/contexturesblog.com\/archives\/2013\/07\/09\/use-check-box-result-in-excel-formula\/\" target=\"_blank\" rel=\"noopener\">Use Check Box Result in Excel Formula<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/excelformulacheckbox.html\" target=\"_blank\" rel=\"noopener\">Change PMT Formula with Check Box<\/a><\/p>\n<p><a href=\"https:\/\/contexturesblog.com\/archives\/2014\/01\/16\/click-a-check-box-to-run-a-macro\/\" target=\"_blank\" rel=\"noopener\">Click Check Box to Run a Macro<\/a><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/xlcondformat03.html\" target=\"_blank\" rel=\"noopener\">Conditional Formatting Examples<\/a><\/p>\n<p><a href=\"https:\/\/contexturesblog.com\/archives\/2020\/09\/17\/excel-check-box-fills-in-billing-address\/\" target=\"_blank\" rel=\"noopener\">Check Box Fills in Billing Address<\/a><\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2021\/05\/orderformcheckbox11.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"check box fills in billing address\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2021\/05\/orderformcheckbox11_thumb.png\" alt=\"check box fills in billing address\" width=\"365\" height=\"259\" border=\"0\"><\/a><\/p>\n<p>___________________________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you ever use check boxes on your Excel worksheets? They&#8217;re handy for choosing options, or marking completed items in a To Do list.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-4260","post","type-post","status-publish","format-standard","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4260"}],"version-history":[{"count":4,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4260\/revisions"}],"predecessor-version":[{"id":4325,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4260\/revisions\/4325"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}