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.

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.

Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in this guide.

Last month, we used conditional formatting to highlight holidays in a matrix-style calendar; we added this enhancement to an earlier article that used conditional formatting to highlight weekends.

Task Management You can use conditional formatting for task management scenarios in Excel, but the most common application for me is highlighting overdue tasks.

[Conditional formatting] allows Excel to apply a defined format to cells that meet specific criteria. You can use a different background color, font color or border.

Create a robust Excel budget spreadsheet to forecast expenses, analyze scenarios, and enhance financial planning accuracy.

Identifying duplicate data using conditional formatting One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

In that article, " Use Excel's conditional formatting to highlight weekends," we created the sheet shown in Figure A. By separating the year, month, and day, you can reuse the same sheet.