Conditional formatting is used when you want to apply styles to a large number of cells using data within cells to determine how a cell is formatted. Maybe you want to draw attention to dates that are ...

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

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 avoid a conditional formatting rule in Excel that doesn’t work as expected Your email has been sent Microsoft Excel’s conditional formatting is a flexible tool that applies formatting on the ...

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

How to add a conditional format that highlights groups in Excel Your email has been sent The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a ...

Excel isn't hard, just learn the right tricks early enough.

We all know that, when you right click on a cell in an Excel worksheet, it is possible to change the format of the cell, from its numeric type, alignment, and text property to its surround and ...