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.

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells ...

Conditional formatting lets you transform static Excel spreadsheets into dynamic canvases of information. You can set different rules with formatting conditions, and the system highlights cells ...

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

Next, in the Conditional Formatting Rules Manager dialog box, click "New Rule." For each of the rules you're going to create to format your spilled array, you'll need to use a formula.

Using Custom Formatting 1] Using Conditional Formatting In Excel, you can format a negative number by creating a Conditional Formatting rule. Select the range of cells containing the numbers.