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.

Learn how to master Excel 365 conditional formatting to transform raw data into actionable insights with this step-by-step guide.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

Unlock the power of Excel conditional formatting! Learn tips, tricks, and advanced techniques for smarter data visualization and analysis.

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.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Need a formula for your Excel spreadsheet in a flash? Try ChatGPT. In this guide, we'll show you how to write Excel formulas using ChatGPT.