Excel - Highlight Active Row

In this short tutorial, I explain how to create a simple macro in Microsoft Excel, which highlights a set of pre defined cells that are based on the location of the active cell. The advantage of using this method is that all existing formatting is preserved after clicking on another cell.