Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

The OR function is a logical function in Microsoft Excel, and its purpose is to determine if any condition you test is True. The formula for the OR function is OR (logical1, [logical2],..). The ...

The article, Use a custom format in Excel to display easier to read millions uses a custom format to make large values more readable. For instance, 1,200,000 displays as 1.2 M instead—the format ...