Here is where the magic wand of conditional formatting comes into play. This often-overlooked feature is your secret weapon ...

When applying this conditional formatting solution to your own work, you’ll have different needs. If you want to highlight a single cell in the subtotaling rows, select only the single column ...