Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

If you need a legend longer than your data, you’ve gone too far.

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

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

Whether you’re using Microsoft Excel 2008 ( ; $400 as part of Office 2008) or 2004, you need some tricks up your sleeve for easing day-to-day tasks, such as entering data or custom sorting, as well as ...

Recently, we have been on a kick with exploring the endless wonders of Google Sheets and workflow enhancers. The capability to edit your spreadsheets in real-time with other team members — even while ...