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
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.

About
You’re currently reading “Excel VB | XLA addin for auto cell colour format”.
- Published:
- Tuesday, August 12th, 2008
- Author:
- Simon Page
- Category:
- Excel
Related
Categories
- Artwork (75)
- Design Inspiration (33)
- Design Resources (10)
- Excel (12)
- Filemaker (5)
- Gadgets (26)
- Music (3)
- Photography (3)
- Photoshop (1)
- Press (7)
- Random (5)
- Software (4)
- Video Gaming (15)
- Wallpaper (6)
Featured
- Album Cover Artwork Inspiration
- Creative Movie Poster Inspiration
- Criss Cross - iPad and iPhone Wallpaper
- Design Inspiration | typography posters
- Exclusive iPad Wallpaper
- Futurism - Limited Edition Prints
- Geometric Silk Scarves
- Geometric Silk Scarves #2
- Inspiring Gallery of Video Game Concept Art
- International Year of Astronomy 2009 Posters
- International Year of Chemistry 2011 Prints
- iPad HD Retina Wallpaper
No comments
Jump to comment form | comments rss | trackback uri