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

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

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

Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.

Where conditional formatting is concerned, this is often the case. In this Excel tutorial, I’ll show you how to apply conditional formatting to a filtered PivotTable in Excel.

Conditional formatting is a popular feature and it’s powerful when combined with other features. For instance, you can’t easily sum values in a range based on a format.