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 the formula element “B3/B4” in cell B5 contains a lurking #DIV/0! error, which is not currently visible simply because at present the condition “B3>0” happens to be false.
As you can see in the screenshot above, the new “Hidden error values” function gives you a table of all such errors, showing exactly the relevant section of the formula (“B3/B4” in the previous example) and the error that it would generate. And in making space for this new function, Rainbow has not lost any of its flexibility in analysing hard-coded numbers; the different options are now available via your Preferences settings.
Version 10.1 also incorporates a wide range of other enhancements, including:
- When you try to run an analysis function on a Rainbow report sheet (instead of the main workbook), automatic detection and switching to the reported-on main workbook.
- A configurable limit to the number of dependents shown in Cell Inspector, to stop it taking forever on a cell that has thousands of dependents.
- In Names Manager, the ability to find defined names buried in data validation and conditional formatting.
- In Format Editor, the option to set cell colours to the default “No Fill” and font colours to “Automatic”.
- Improved Log File viewing, and hyperlinks that work even on unsaved workbooks.
- Restructured User Guide that should make it easier to find the function you’re looking for.
So why not start the New Year by downloading a free trial of this new version of Rainbow?!