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.

Microsoft Excel’s RANK.EQ () function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ () with a conditional formatting rule to highlight ...

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

Jazz up your Microsoft Excel workbook by creating conditional statements to visually represent trends within your data. The Conditional Format tool allows you to define conditional statements to ...

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.

As mentioned in the intro, you can use conditional formatting to make certain values stand out with colored text and backgrounds. You can, for example, indicate problem data values in red, and ...

For instance, you can use conditional formatting to highlight cells in red if their values fall below a certain number or use another color for values above a target. It can also be applied to ...

You can automatically have cells turn certain colors based on the text within those cells. This is easily done using one of the many types of conditional formatting.

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