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

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

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

Learn how to use IF & nested IF statement in Google Sheets. & highlight a row using conditional formatting, set up multiple conditional formatting rules.

This should yield an answer of 6 if today is a weekday, 5 if today is a weekend day. We can also use this feature in conditional formatting. But we'll need to do quite a bit more work on it first. IF ...

Search Google Sheets with conditional formatting A unique way to search in Google Sheets involves using the Conditional Formatting feature. Do this if you want your search term to be highlighted ...

If you’ve used table formatting you can sort your data by the conditional formatting using the filter drop-down. Just click the down-facing arrow in the column heading you want to sort your ...

If there are too many of these custom formulas on a single sheet, Google Sheets may being to throw errors. (It's not clear how many are "too many." I began to see some errors when I had five different ...