Tracking financial reports, budget variances, profit margins, or inventory adjustments in Google Sheets often requires immediate visual distinction between positive gains and negative deficits. While standard black text with a minus sign indicates negative values, converting negative figures into bold red text or wrapping them in parentheses immediately draws attention to key discrepancies without cluttering your spreadsheet.
Google Sheets provides two robust methods to accomplish this: Custom Number Formatting and Conditional Formatting. Custom number formatting alters how values are displayed without evaluating dynamic formula logic, making it lightweight, fast, and ideal for large workbooks. Conditional formatting, conversely, allows you to apply distinct text colours, background cell highlights, and custom styles based on dynamic numerical criteria.
In this guide, you will learn how to configure both approaches step by step, allowing you to choose the exact visual styling that best suits your data presentation.
Method 1: Format Negative Numbers in Red Using Custom Number Formatting
Custom number formatting is the most efficient way to change number appearances in Google Sheets. It modifies the visual presentation layer without altering the underlying raw data or slowing down calculation engines in data-heavy sheets.
Step 1: Select Your Data Range
Click and drag your cursor over the numerical cells you wish to adjust. To format an entire column, click the column letter header at the top (for example, column C).
Step 2: Open the Custom Number Formats Dialogue
- Navigate to the top menu and select Format.
- Hover over Number.
- Scroll down to the bottom of the sub-menu and click Custom number format.
Step 3: Apply the Red Colour Syntax Code
Google Sheets syntax structures custom formats in distinct semicolon-separated sections: Positive;Negative;Zero;Text. By prefixing the negative segment with a bracketed colour tag like [Red], Google Sheets automatically applies red styling exclusively to negative entries.
Paste one of the following syntax strings into the format input bar at the top of the dialogue box:
- Standard Currency with Minus Sign in Red:
£#,##0.00;[Red]-£#,##0.00;£0.00
(Replace £ with $ or your preferred currency symbol.) - Accounting Style with Parentheses in Red:
#,##0.00;[Red](#,##0.00);"-"
(This formats negative values enclosed within red brackets and displays zero as a clean dash.) - Simple Integer Format with Minus Sign in Red:
#,##0;[Red]-#,##0;0
Step 4: Confirm and Apply
Click the green Apply button. All negative numbers across your selected range will immediately render in red, while zero and positive numbers retain standard black formatting.
Method 2: Highlight Negative Numbers in Red Using Conditional Formatting
If you wish to apply custom background fills, bold styling, or apply colour rules across entire rows when a value dips below zero, conditional formatting provides the necessary flexibility.
Step 1: Highlight the Target Cells
Select the column, row, or table matrix containing your numeric metrics.
Step 2: Launch the Conditional Format Rules Panel
- Click Format in the main toolbar.
- Select Conditional formatting. A sidebar pane will appear on the right side of the screen.
Step 3: Configure the Comparison Condition
- Ensure the Single colour tab is selected at the top.
- Verify that your target cell range is accurately populated under Apply to range.
- Under the Format rules drop-down menu, select Less than.
- In the Value or formula input field directly below, enter:
0
Step 4: Set the Visual Styling
Under Formatting style, configure your preferred visual alert:
- To colour the text red: Click the Text colour icon (letter “A”) and choose a prominent red shade from the palette.
- To add a soft background tint: Click the Fill colour bucket icon and choose a subtle light red or pastel coral background so numbers remain legible.
- To emphasize the alert: Click the Bold icon (letter “B”).
Step 5: Save the Rule
Click Done at the bottom of the sidebar. Any number strictly less than zero will now dynamically update to display your chosen red formatting. If an updated calculation turns the value positive, the formatting automatically clears.
Key Differences: Custom Formatting vs Conditional Formatting
Selecting the right technique depends on your sheet complexity and workbook scale:
| Feature | Custom Number Formatting | Conditional Formatting |
|---|---|---|
| Performance Impact | Extremely fast; zero overhead on sheet calculation. | Evaluates continuously; hundreds of rules can cause lag. |
| Styling Scope | Text colour only (limited to basic palette tags like [Red]). | Full styling: text colour, cell fill colour, strikethrough, bold. |
| Data Structure | Handles currency signs, decimal places, and parentheses. | Alters style only; does not define decimal precision or currency tags. |
| Row Highlighting | Cannot highlight adjacent cells in a row. | Can highlight full rows using custom formula criteria. |
Troubleshooting Common Formatting Issues
Why Did Numbers Fail to Turn Red?
If numbers entered with minus signs remain black after applying formatting, the values may be stored as text strings rather than true numerical data. This frequently occurs when importing CSV exports from external banking systems or third-party CRM platforms. Check for leading apostrophes (') or non-standard minus characters, and use the VALUE() function or Data > Data clean-up tools to convert text representations into numbers.
Can You Use Hex Codes in Custom Number Formats?
Google Sheets custom number formats do not support custom hex codes (such as #FF0000). Custom formats exclusively recognise primary colour names such as [Red], [Blue], [Green], [Yellow], [Magenta], [Cyan], [Black], and [White]. If your organisation requires exact brand colours or custom hex tints, use Conditional Formatting instead, where the colour picker accepts custom hex values.