Sunday, 17 June 2012

Highlighting Cells

Sebastian says "I've just found your way to do highlight the active row, it's brilliant! even with Undo function."

He goes on to ask "I'm wondering, how hard is it to make a .xla of this code so I can distribute it around the office, basically I won't have to copy/paste and add conditional format every single time someone wants to use it in a workbook."

Well, yes, the easiest solution is to make an add-in which will add the formatting and code. So I decided to make one. And when I make things, I usually try to add some extra functionality so the add-in I made one to highlight rows, columns or both. Refer to the below pics.

Row Highligting

Column Highligting

Row and Column Highligting

Be warned. This add-in will delete any existing conditional formatting in a range where you use it. It will also insert the VBA code as required, although this should not cause a problem.

Here's the download link if you want to try it.


  1. Hi Andrew,

    Awesome job! It works great on Excel 2003, sadly can't get it to work on 2007, it keeps closing down whenever I enable any option in the highlighter menu.
    "Excel has encountered a problem and needs to close. We are sorry for the inconvenience"

    Any suggestions?


  2. Hi Sebastian

    Sorry, I’ve tested it in 2007 and 2010 and it’s working…

    All I can think is that there’s something wrong with the install. Try using it in another 2007 PC and let me know what happens.

    Also, have you trusted access to the VBA project object model?


  3. Hi,

    Just upgraded to latest Service Pack for Office and now works great!


  4. I have also tested in 2007, works for me as well.

  5. Working just great in 2007 and 2010. Thanks Andrew.

  6. Thanks for letting me know guys, sorry not to reply earlier :-)