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?

www.sysmod.com/xltest

Advertisements

About Patrick O'Beirne, spreadsheet auditor

Patrick provides consultancy and training in spreadsheet development, auditing / testing and model review; and the Excel 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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s