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.

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.

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.

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

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.