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.

Open the Excel spreadsheet containing the columns you want to compare. Select the data in both columns, excluding the heading. In the Styles section in the Home tab, click on Conditional Formatting.

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 ...

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.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.