Category Archives: News

New easy menu system in Rainbow 12.1

New easy menu system in Rainbow 12.1

We’ve been thinking for a while about how to make it easy to find all Rainbow’s functions, even the ones hidden away under the buttons on the Rainbow tab. And we’ve now found a way to do this with a new easy menu system that works seamlessly within the existing tab.

As you can see from the composite screenshot above, there is a new Menu button at the left of the Rainbow tab. This gives you a clear, easy menu of all Rainbow’s functions laid out in a table, where the top row shows all the main buttons and each column lists the functions under each main button. You can hover over any square in the table to see a brief description of the function, and then just click to run it. So if you’re not sure where to find a particular Rainbow function, just click the Menu button and you’ll see it right there on screen.

On the same theme of making Rainbow as easy as possible to use, we’ve simplified the Undo Changes function. Previously if you didn’t have any formatting information saved (with the Save Format function), you had to go to Clear Cell Colours and then Delete Comments to get rid of Rainbow’s formatting and other changes. Now it’s all handled seamlessly in the enhanced Undo Changes function, as you can see in the screenshot above.

We’ve also fixed an issue with the Logic Colours function, and added a new system to move this and other information windows (for the Issue Tracker and the Cell Inspector) out of the way of whatever cell you’re examining. So altogether we hope you’ll find that the new easy menu system and other new features make using Rainbow an even more intuitive experience than before!

Find hidden cells and risky macros

Find hidden cells and risky macros

In version 12 of Rainbow we’ve added several new risk analysis options to the Risk Map function. We’ve done this by moving some “mapping” options from the last Risk Map tab across to the Logic Analysis function (see previous post). And we’ve also added an option to analyse any VB macro code in the workbook.… Continue Reading

Rainbow 12.0 brings new functionality

Rainbow 12.0 brings new functionality

We’re proud to announce the release of Rainbow version 12.0, which brings more new features than we can cover in a single post. Some of the highlights are: Analysis options in Risk Map and Logic Analysis increased from 36 to 48. Recognition of new features in Excel like dynamic arrays and threaded comments. New functions… Continue Reading

Usability improvements in Rainbow 11.4

Usability improvements in Rainbow 11.4

With Rainbow 11.4 our main focus has been on usability rather than new functions. We’ve gone behind the scenes to optimise some of the user interface code, and you’ll now find that Rainbow loads more quickly, and starts individual functions more smoothly and with less screen flicker. You’ll also notice that you can scroll up… Continue Reading

Corporate integration in Rainbow 11.3.1

Corporate integration in Rainbow 11.3.1

With Rainbow 11.3.1 we’ve added some further features that will help Rainbow integrate smoothly into a large-corporate environment. In particular, we’ve given you control over two of Rainbow’s functions (Check For Updates and Uninstall) that could potentially cause problems in a corporate IT environment by (a) running a VBScript file and (b) modifying the corporate… Continue Reading

Quickly undo changes with Rainbow 11.2

Quickly undo changes with Rainbow 11.2

Rainbow has offered an Undo Changes function for many years, and we made it much more visible in the recently redesigned menu (in version 11.0). However, as you probably know, it was only able to operate if you had already used the Save Format function to create a “format restore point” to which Rainbow could… Continue Reading

Fix merged cell problems with Rainbow 11.1

Fix merged cell problems with Rainbow 11.1

If you ask any professional Excel developer about merged cells, they will almost certainly say something that can’t be repeated here! Merged cells can produce incorrect calculation results, prevent sorting and filtering in data tables, cause errors in macros, and waste large amounts of time when spreadsheets have to be updated. Of course if your… Continue Reading

Manage all your spreadsheets with Rainbow 11.0

Manage all your spreadsheets with Rainbow 11.0

You may have already noticed that with the release of Rainbow version 11.0 there are now two editions of Rainbow that you can download from our Home page: Rainbow Analyst Professional (Rainbow Pro) and Rainbow Governance. And if you download Rainbow Governance after having used an earlier version of Rainbow Pro, you will immediately see… Continue Reading

Back to topAdministration