Tag Archives: anomaly

Conditional Format recalc oddity

This came up on the Excel-L list recently – maybe some reader can explain it. The requirement was to base a Conditional Format on a user-defined¬†expression entered as text. The easy answer is for them to enter it as a … Continue reading

Posted in Excel/VBA | Tagged , , , , , , , | Leave a comment

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 … Continue reading

Posted in Excel/VBA, Risk | Tagged , , , , , , , , , , , , , | Leave a comment