Auto-Highlight the Active Row When a Cell is Selected

Something different on theSmallman today - actually something different all together. Since starting my Excel website and subsequent blog over 3 and a half years ago I have created over 300 pages from financial modelling to dashboard design to unlocking Excel's scripting dictionary. I have writen every word myself and have drawn extensively on my posts on Ozgrid and Chandoo forums. Today for the first time someone else is going to do the instructing. The two handsome gentleman above are Kasper and Mikel.

Tags Excel, Autohighlight, Auto, highlight, Active, Row, cell, selected

Excel VBA Colour Function

This is an alternative to conditional formatting. The following will detect the colours Red, Yellow and Green in a particular cell. It will add the name of the colour – good for those colour blind individuals. It is a custom function so needs to used in conjunction with a formula or in a VBA procedure.

Tags Excel, VBA, Colour, cell, function, giddyup