Automated formula editing in Rainbow 12.6.1

Automated formula editing in Rainbow 12.6.1

Rainbow’s Formula Scan function lets you see instantly where there are inconsistent formulas that differ from the surrounding cells. So in the composite screenshot above, you can see there is a block of inconsistent formulas highlighted in red. And if you look...
New search and audit sampling in Rainbow 12.6

New search and audit sampling in Rainbow 12.6

In Rainbow 12.6 we’ve introduced two new features which make Rainbow a powerful audit sampling tool. These are a new Find Cells function, and a major enhancement to the Sample Data function. The new Find Cells function gives you a powerful tool to find any of 6...
Updated Structure Map for large workbooks

Updated Structure Map for large workbooks

We’re very pleased with our new Structure Map function (see previous post) and its ability to visualise how a spreadsheet operates. But we didn’t discover till later that it was going to have problems with really big workbooks. So in Rainbow version 12.5.2...
Visualise workbook structure with Rainbow 12.5

Visualise workbook structure with Rainbow 12.5

When someone sends you a spreadsheet to look at, do you ever wish there was an easy way to see what’s going on? Well, now there is, with the new Structure Map function in Rainbow 12.5. As you can see in the composite screenshot above, this gives you a simple and...
Instant menu and more in Rainbow 12.4.4

Instant menu and more in Rainbow 12.4.4

Since introducing the new Menu Guide in version 12.4.2, we have been looking at how to make it even more useful. And we think we’ve now found the answer: a Menu Guide that all fits on one screen, and that’s instantly available when needed. As you can see...