Excel VB | XLA addin for auto cell colour format

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 some improvements to it; which will let you import and export templates, change border thickness and also a couple of speed enhancements for 2007 - so watch this space.

The basic idea of the addin is that:

You select the area of the Excel sheet you want to format
Click the “Colour Format” button
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)
Click okay and the sheet is formatted

screen_grab

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.

excel

colour_code.zip

Twitter

Battling on iPad using awesome Teamviewer RDP app with poor bandwidth. Got project files organized & sent along with some new prints to boot. (2 hrs ago) follow me...