News

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 ...
How to create conditional formatting in Google Sheets The easiest way to set conditional formatting on Google Sheets is by using the Format option in the Google Sheets toolbar.
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 ...
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 ...
Explore and use preset rules for conditional formatting Thanks to Microsoft’s preset rules, you don’t necessarily need to create a custom rule from scratch.
Use the dropdown menu to choose your formatting style, or opt for the Custom Format option if you want to create a unique look. Click OK to apply the conditional formatting to your selected cells.
Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.
In this tutorial, I’ll show you how to use a conditional format to highlight the top-three ranking values. First, we’ll look at the two functions used and then we’ll get down to business by ...
Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.
Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel, but many users aren't aware it exists.