Excel is one of the most popular Office applications, if the email I receive from readers is any indication. This month, two Excel users asked for guidance using two of Excel's most popular features - ...

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

It’s not hard to add an alternating band format to a table by applying a table style. It’s quick and easy, but it’s limited. You’ll get a single-row fill color that alternates with a row of white (or ...

How to use a conditional format to highlight subtotal rows in Excel Your email has been sent If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting ...

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

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