by Mike Shallcross on January 17, 2010
We have just released two new versions of Rainbow Analyst for the New Year! Both the Professional and the Personal versions have been upgraded:
- The new Professional version 6.0 is fully integrated with Microsoft’s Ribbon interface (for Excel and Office 2007), and it incorporates other improvements which we think represent overall a major advance in usability. For more details see below and on other pages.
- The new Personal version (version 3.4) now incorporates Inter-Sheet Logic and Comparison functions as well as other improvements, and it is still completely free for personal, non-commercial use.
You can download and try out both versions on our Download page; and if you’re a spreadsheet professional using Excel 2003 or earlier, we are continuing to offer our well-established Professional version 5.1.
If you’re currently an individual (single licence) user of Rainbow Analyst Professional version 5.1, you can upgrade to version 6.0 without charge. If you are a corporate (site licence) user, please contact us for upgrade information.
by Mike Shallcross on January 17, 2010
Many professional Excel users have continued to use Excel 2003 rather than migrating to the completely new Ribbon interface in Excel 2007. However, in Rainbow Analyst Professional version 6.0 we have recognised that an increasing number are making the move, and we have upgraded Rainbow Analyst to take full advantage of the Ribbon interface.

The new version version occupies a separate “Rainbow” tab on the Ribbon (click above to see the full-size image), which has allowed us to arrange and group Rainbow’s functions much more clearly than on the previous drop-down menu. There is also a “supertip” for each function which briefly explains its use when you hover the mouse over it.

The new version has also enabled us to implement interactive functionality in place of two Rainbow features that used to involve a slightly clunky use of Excel worksheets. The first such feature is the set of cell mapping options that determine how Rainbow colours or maps different types or groups of cells. You can now view and interactively edit all these options from the Cell Mapping button on the Ribbon (as above). And if you have created a Rainbow map and want to check what the different colours mean, you can now do so quickly and easily by clicking the Cell Mapping button.

The other Rainbow function that is now interactive is the User Guide. We realised that most users were not making much use of this, and so we have now made available nearly all sections of the User Guide in the form of context-sensitive help, which can be accessed from the new Help button on nearly all dialog boxes.
In addition to these changes, we have also included a number of other minor enhancements:
- a date and time stamp on all reports (as shown on our Example page;
- a message advising when the Compare Worksheets function has not found any matching sheets to compare;
- improvements in the way Rainbow deals with protected sheets and chart sheets.
So if you’re using Excel 2007, go to our Downloads page and try version 6.0 for yourself!