One of our customers told us Rainbow was worth buying for its comparison function alone, and another customer found an unexpected use for it in resolving version conflicts. Rainbow’s Comparison Toolbox function provides you with a whole toolbox of different options, allowing you to compare different workbooks, worksheets or ranges. And at the same time Rainbow lets you choose whether you want to compare formulas or results, either with or without constant values.
If you are comparing formulas, Rainbow can group together differences which are due to copied formulas in the two worksheets or workbooks. This can make it very much easier to see what is really happening; instead of a report showing hundreds of individual differences, you can see that (for instance) they are all due to a change in one formula, copied over hundreds of cells.
As well as generating a colour-coded report, the Comparison Toolbox function highlights differences in the actual worksheet(s), and you can jump straight from the report to the relevant cells in the two workbooks. And Rainbow will attempt to adjust automatically for differences caused by inserted or deleted rows and columns, as you can see in the example above.
So whatever kind of comparison you need to carry out, Rainbow will almost certainly be able to help! Just click the button below to install your own copy:
(Note: If Windows SmartScreen reports the download file as an “unrecognised application”, just click “More info” in the SmartScreen message, then click the “Run anyway” button.)