If you need a visual clue to hype a worksheet, use Excel’s Conditional Formatting feature to help values stand out. If you maintain inventory in an Excel worksheet, you probably need to know when ...

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel. Microsoft Excel PivotTables range from easy to complex, and data and reporting ...

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

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

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

Conditional formatting and PivotTables are two of Excel's most powerful features, but they don't always play nicely together. Apply a standard color scale or data bar to a PivotTable, and a refresh, ...

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