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

This is still the only way to be certain of undoing all Rainbow’s changes, but in version 11.2 we have introduced a quick-and-easy alternative. As shown in the composite screenshot above, if you click Undo Changes when there is no available format restore point, Rainbow will take you to the newly updated Clear Cell Colours function.

This function is now able to selectively clear just the cell colours generated by Rainbow, leaving other cell colours untouched. Of course if Rainbow has overwritten another colour then the previous cell colour will not be restored, but in many cases this new functionality will provide an effective alternative to Undo Changes.

If you’re wondering how Rainbow knows which cell colours it has generated, the answer is that the colours used by Rainbow have been specifically designed to be very slightly different (with a slightly different RGB value) from the colours generally available in Excel. There is still a small chance that a workbook may happen to contain one of the Rainbow colours, but this is really quite unlikely.

The other main change in Rainbow 11.2, as you can see above, is that (some of) the icons have been updated. The latest version of Office 365 (depending on which Microsoft release channel you have selected) features new icons with a cleaner and simpler appearance. However, some of these no longer suited their function on the Rainbow ribbon menu, and so we have made a number of changes to ensure a clean and consistent appearance for the Rainbow menu. We hope you like it!

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

Find more hidden errors with Rainbow 10.1

Find more hidden errors with Rainbow 10.1

Rainbow has always been about finding hidden errors, and version 10.1 introduces a new analysis option (in Risk Map and Formula Scan) that detects error values lurking hidden in your IF() statements. A simple example would be where cells B3 and B4 contain the value 0, and B5 contains the formula “=IF(B3>0,B3/B4,0)”. In this case… Continue Reading

Rainbow 10.0 adds perpetual licence

Rainbow 10.0 adds perpetual licence

For Rainbow 10, we’ve responded to requests from a number of users for Rainbow to include a perpetual licence. So all Rainbow version 10 licences will now allow you to continue using the same version of Rainbow even after the licence period has expired (but you will not be able to install any updates released… Continue Reading

Rainbow 9.3 for Excel 2016

Rainbow 9.3 for Excel 2016

Microsoft have always said that VBA (the language in which Rainbow is written) will be supported for the foreseeable future. However, it’s not uncommon for there to be a few teething problems with the VBA implementation in a major new release such as Office 2016. This happened with Office 2010, where there was an issue… Continue Reading

Save 20% and get answers faster

Save 20% and get answers faster

As it’s still the holiday season, we’re offering 20% off Finance and Business licences for the latest version (9.2.4) of Rainbow Pro until September 12th! And for this you get our fastest ever implementation of the Summary Report; particularly if your spreadsheet is data-heavy, the Summary Report will now zip through in a fraction of… Continue Reading

Rainbow 9.2 saves time for your team

Rainbow 9.2 saves time for your team

With Rainbow 9.2 we’ve built on the behind-the-scenes changes in version 9.0 to deliver significant new front-end capabilities: We’ve integrated Rainbow’s in-depth testing capabilities (in Risk Map and Logic Analysis) into the Formula Scan function (renamed from Formula Groups). Formula Scan can now perform a battery of tests on each formula as it scans, and… Continue Reading

New Rainbow Pro 8.2 more intuitive than ever

New Rainbow Pro 8.2 more intuitive than ever

We’re always looking for ways to make Rainbow Pro easier to understand and use, and in the just-released version 8.2 we’ve built on our “interactive reports” technology to deliver a whole new level of product integration. You can see this very clearly in the Summary Report screenshot above, showing the 20 interactive buttons (in column… Continue Reading

Back to topAdministration