Cell Formatting
Not a function, direct styling. Bold, fill color, and number format change how a value reads, never what it is or what it calculates to.
This is the one part of Excel covered here that never changes a value. =SUM(B2:B4) totals the same number whether B2 displays as 1200 or $1,200.00. Number format is purely a display layer sitting on top of the real underlying value, and Bold and Fill Color are purely visual too.
That's also why formatting can't be "wrong" the way a formula can be. It can only be mismatched to what a range is supposed to communicate, a header that doesn't stand out from the data beneath it, or a dollar column that reads as bare integers with no currency symbol in sight.
Syntax
| Argument | Description |
|---|---|
| Range | Required. The cell or range the formatting applies to. Select it first, the same way you would before opening Conditional Formatting or a filter. |
| Property | Required. Bold (on/off), a fill color, and/or a number format. More than one can apply to the same range at once. |
A real example: formatting a money column without touching its values
A client balance stored as a plain number, formatted to actually read as currency:
The cell now displays $1,240.00, but the value stored underneath is still exactly 1240; any formula elsewhere that references B2 still sees the plain number, unaffected by how it happens to be displayed.
Worked examples
| A | B | |
|---|---|---|
| 1 | Category | Amount |
| 2 | Rent | 1200 |
| A | B | |
|---|---|---|
| 1 | Client | Amount Due |
| 2 | Nova Retail | 1240 |
(the stored value is still 1240; only the display changed)
Common mistakes
- Selecting the whole table instead of just the range that needs it. Formatting the data rows along with the header defeats the point of a header standing out.
- Expecting a number format to change what a formula computes. It never does; only what the cell displays.
- Layering so many fill colors and fonts that nothing stands out anymore. A header usually needs exactly one thing (bold, or a fill) to read clearly, not every option at once.
Related functions
Try it yourself
A free, graded practice exercise using this exact function: instant feedback, no signup required.
Practice cell formatting →