Sometimes when I’m working with Google Sheets I just want to highlight a row really quickly without going through the steps of
- selecting a row
- opening the color menu
- selecting a color
By highlighting rows or cells using conditional formatting in combination with a custom formula, you just have a single step:
- Enter any character in a cell
Here’s how to set it up:
- Create a new column
- Select the columns you want to highlight
- Right-click on the selected columns and select “conditional formatting”
- Under “Format cells if…” select “Custom formula” and enter a simple little formula like
=$C:$C>“”, where $C:$C is the new column in which you can later enter any character to mark the row.
The above formula basically says, “highlight a row in the selected areas whenever the cell in the specified column is not empty (i.e. greater than nothing).”
Now you can skim over rows and rows of data and mark any of interest with one keystroke.