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

When you’re parsing through large amounts of data in a Google Sheets spreadsheet, conditional formatting can help you find those bits of information that you want. Conditional formatting helps to ...

Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets users format cells based on certain conditions, including the date contained in a cell and how far away that ...

Add Yahoo as a preferred source to see more of our stories on Google. Excel holiday information Last year, I showed you a dynamic approach to using conditional formatting to highlight weekends in a ...

This Google Sheets Advanced Tutorial explains IF, VLOOKUP, INDEX MATCH, and pivot tables, plus macros and Apps Script for ...

Here's how to create a heat map in Google Sheets. This is the easiest method, which is the conditional formatting feature.

Formatting every other row is easily accomplished using conditional formatting. Fortunately, conditional formatting can handle something more specific, formatting every even or odd row. Many users ...

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