In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

If the formula evaluates to `TRUE` (or any non-zero value), Excel applies the formatting. If it evaluates to `FALSE`, `0`, or an invalid value, no formatting is applied.

Excel percentage formulas can help with many everyday applications. We'll walk through several examples, including turning fractions to percentages, and calculating percentage of total, increase ...

The results are Excel serial numbers, so you must choose Format>Format Cells>Number>Date, and then select a format from the list. Formula: =DATEVALUE(H33) 6. =FORMULATEXT ...

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.

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

If you want to unlock all the previously locked formula cells in Excel, simply select the cells with formulas as discussed in step (3) above. Then, open the Format Cells dialog and uncheck the ...

How to Format Relative References in Excel. ... This format is useful in formulas where you need to specify a range, such as "=SUM(A1:B5)" to add all the cells in the range.