Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

When using conditional formatting, the first option you have is to use preset conditions — formatting options that are built into Excel.

However, it’s easy to grab your attention with a format that alerts you to the due date. In this article, we’ll use conditional formatting to highlight due dates.

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

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

As an example, suppose you have an Excel workbook that contains each student’s numerical course grades, but you would like a visual way to differentiate each student’s letter grade (A, B, C, D, or F).

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