The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

Excel is a very handy tool for working with data. It has many built-in features, like conditional formatting, which helps you to format and highlight data based on certain rules. The rules can be ...

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.

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

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

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Color. Whether you apply a background fill or font color manually or by using conditional formatting, you can use that color to sort your data.

Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.

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.