Have you ever found yourself frustrated with an Excel workbook that seems to lag, break, or throw errors at the worst possible time? If so, there’s a good chance the culprit is one of Excel’s most ...

For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...