Free Excel formula highlighting tool

My main product is the XLTest addin that does a comprehensive shakedown of Excel workbooks. I’ve picked out the most popular feature, colour coding cells by formula region, and give it away as a free taster, the XLTest Colorizer. It can colour a sheet with 10,000 formulas in a second or two. The picture at the top of this blog shows you what it looks like.

It’s a very effective way of using the human eye’s ability to recognise anomalies in patterns to quickly see formulas that are inconsistent with those around them.

Let me know what you think of it!  Did I mention it’s free?

About Patrick O'Beirne, Excel/VBA developer

Patrick provides consultancy and training in spreadsheet automation, data analysis, testing and model review; and the Excel spreadsheet auditing addin XLtest
This entry was posted in Excel/VBA, Risk and tagged , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s