Yearly Archives: 2017

How to use Excel's conditional formatting to highlight the same row and column as the active cell

Highlighting the entire row and column for the active cell in a complex sheet could prove helpful for quickly reviewing dependent or related values. Fortunately, adding a conditional formatting rule to do so is easier than you might think. You'll need two expressions and a simple VBA procedure. As you might imagine, there are lots…
Read more