We treat Sheets like a piece of digital paper. We enter data, and when we need to find an answer, we manually scroll. We waste time hunting for rows or applying temporary filters that shuffle our data ...

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, ...