Using conditional formatting in Excel to automatically add horizontal lines between different groups in a table
by Daljit Dhadwal
In the following screencast I show how to use conditional formatting in Excel to automatically create horizontal lines between different groups of data in a table. When applying conditional formatting you need to pay particular attention to properly setting up the cell references (absolute, relative, or mixed) in the conditional formatting formula.
