We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...

This week's tutorial covers a number functions in Google's Spreadsheet app, Google Sheets. Here we take a practical look at using weekdays in calculations, introduce 'if' statements and learn how to ...

Common wisdom says you just can't apply conditional formatting in a Google Apps spreadsheet using data from a different sheet. But here at THE Journal, we laugh in the face of wisdom, common or ...

We show you how to highlight duplicates in Google Sheets using the COUNTIF and ARRAYFORMULA functions under the conditional format rules.

The Sheets web app already has these new features, which include most notably the ability to add gradients that are conditional upon the value of the individual cell.

We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...