{"id":107,"date":"2008-08-12T13:06:04","date_gmt":"2008-08-12T12:06:04","guid":{"rendered":"http:\/\/simoncpage.co.uk\/blog\/?p=107"},"modified":"2008-10-19T14:58:48","modified_gmt":"2008-10-19T13:58:48","slug":"excel-vb-xla-addin-for-auto-cell-colour-format","status":"publish","type":"post","link":"https:\/\/simoncpage.co.uk\/blog\/2008\/08\/excel-vb-xla-addin-for-auto-cell-colour-format\/","title":{"rendered":"Excel VB | XLA addin for auto cell colour format"},"content":{"rendered":"<p>I created this a while ago and have just tested it in Excel 2007 and it works a treat. I am going to update this post later with\u00a0some improvements to it; which will let you\u00a0import and export templates, change border thickness\u00a0and also a couple of speed enhancements for 2007 &#8211; so watch this space.<\/p>\n<p>The basic idea of the addin is that:<\/p>\n<ol>\n<li>You select the area of the\u00a0Excel sheet you\u00a0want to format<\/li>\n<li>Click the &#8220;Colour Format&#8221; button<\/li>\n<li>Dialog box (as shown below) opens and you select the colours you want the cells formatted to based on the different types ( Text, References, Numbers, Percentages, Formulas, Logical, Errors and Arrays)<\/li>\n<li>Click okay and the sheet is formatted<\/li>\n<\/ol>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-108\" title=\"screen_grab\" src=\"https:\/\/simoncpage.co.uk\/blog\/wp-content\/uploads\/2008\/08\/screen_grab.gif\" alt=\"\" width=\"483\" height=\"447\" \/><\/p>\n<p>I have included the XLA addin below (zipped) which you are welcome to use. If you find any bugs or enhancements you think would be good then let me know.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-98\" title=\"excel\" src=\"https:\/\/simoncpage.co.uk\/blog\/wp-content\/uploads\/2008\/08\/excel.gif\" alt=\"\" width=\"91\" height=\"92\" \/><\/p>\n<p><a href=\"https:\/\/simoncpage.co.uk\/blog\/wp-content\/uploads\/2008\/08\/colour_code.zip\">colour_code.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I created this a while ago and have just tested it in Excel 2007 and it works a treat. I am going to update this post later with\u00a0some improvements to it; which will let you\u00a0import and export templates, change border thickness\u00a0and also a couple of speed enhancements for 2007 &#8211; so watch this space. The [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[26],"tags":[63,123,79,78,77,117,27,119,121,130],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/posts\/107"}],"collection":[{"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=107"}],"version-history":[{"count":0,"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"wp:attachment":[{"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/simoncpage.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}