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

And it will be automatically updated in Sheet1 whenever I change the text in Sheet2. Adapting This Trick for Conditional Formatting Now, just as we learned last time around, we can use "if" statements ...

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.

You can visualize deadlines using conditional formatting in Excel. Suppose you manage a marketing campaign with various tasks, each with a specific deadline. Here is how you can set it up in Excel.

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.

Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

As mentioned in the intro, you can use conditional formatting to make certain values stand out with colored text and backgrounds. You can, for example, indicate problem data values in red, and ...

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.