Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

Microsoft Excel 2019 is a powerful management tool for many business owners. It combines the simplicity of a cell-based information system with formatting features that both highlight important data ...

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

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

Your spreadsheet skillset likely boasts an at-least-passing acquaintance with Excel’s conditional formatting feature – really a miscellany of features – that impose user-specified formatting(s) upon ...

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

Quip, a startup with mobile apps for crafting and collaborating on documents, has turned on some useful capabilities when it comes to working with spreadsheets. Now you can click a couple of buttons ...

My first instalment on conditional formatting broached the standard, by-the-book protocol for applying conditions to cells: selecting the cells you want to subject to the potential formats, and then ...

Microsoft Excel 2011 is packed with new features, but three areas in particular are worth taking some time to learn. 1. Themes and Cell Styles spruce up your spreadsheets Better-looking spreadsheets ...

Is Apple’s iWork a viable alternative to Microsoft Office? To find out, we asked Rob Griffiths—our go-to expert on spreadsheets—to use Excel 2008 and Numbers ‘08 to create the same project, ...