Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out. Excel lets you set some conditional formatting rules ...

How to easily sum values by a cell’s background color in Excel Your email has been sent Color is a great visual tool in most any sheet. That’s why so many of Excel’s built-in features include color.

Later, we'll add an IF() function that returns a subtotal for each day. How to calculate conditional subtotals in an Excel revenue sheet Your email has been sent Adding a condition to a simple revenue ...