Excel is many things: powerful, useful, colorful, handy, but its logic functions can be challenging to newcomers due to their implied logic, and a shorthand syntax designed to fit on a single line in ...

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

How to use the selected value in a combo to determine conditional formatting in Excel Your email has been sent Formatting values to categorize them or get our attention is a common practice in ...

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

There's a fine line between a well-formatted Microsoft Excel worksheet and one that's full of issues that take time to fix. Whether you're an Excel newbie or a seasoned pro, avoiding these formatting ...

In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that ...

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