Excel Conditional Formatting to Bold Cells Automatically

Yes. In Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting > New Rule, set the condition, and click Format > Font > Bold. Excel applies bold automatically whenever a cell meets the rule, and removes the conditional bold when the condition is no longer true.

What bold conditional formatting does

Conditional formatting changes a cell’s appearance in response to its value or to a formula-based test. Bold is one of the font effects you can apply, alongside options such as font color, fill color, and borders. It is useful when readers need to notice particular records without manually scanning every row or repeatedly changing formatting as the data changes.

For example, a task list might bold deadlines that are overdue, or an inventory sheet might bold products whose stock is below a chosen level. The cells still contain their original values; the rule changes how Excel displays them. If the relevant value changes, Excel reevaluates the condition and updates the appearance.

This is different from pressing Ctrl+B. Manual bold is a direct formatting choice that remains until someone changes it. Conditional bold is attached to a rule and depends on whether the rule evaluates as true.

Create a rule using a built-in condition

For simple tests, use one of Excel’s built-in conditional formatting rules. The exact choices depend on what you select, but common options include comparing a cell with a number, finding text, or identifying duplicate values.

Select the cells you want Excel to format. For example, select B2:B100 to check values in that range.
Choose Home > Conditional Formatting > New Rule.
Choose a rule type, such as Format only cells that contain, and set the condition. To find values below a stock threshold, select Cell Value, less than, and enter the threshold.
Choose Format, open the Font tab, and select Bold in the Font style list.
Choose OK to close the Format Cells window, then OK again to save the rule.

For instance, if B2:B100 contains stock counts, a rule for values less than 10 will make any count under 10 bold. A count of 9 qualifies; a count of 10 does not. If the stock count later rises to 10, the conditional bold disappears because the rule is no longer true.

You can also create a rule from a selection using other entries under Home > Conditional Formatting, such as Highlight Cells Rules. Those shortcuts are convenient for common tests, but New Rule gives you access to the full rule setup and the Format button.

Use a formula for more specific conditions

A formula rule is helpful when the condition involves another column, combines multiple tests, or needs to apply formatting to an entire row. In the New Formatting Rule dialog, select Use a formula to determine which cells to format. Enter a formula that returns TRUE for rows to emphasize, then choose Format > Font > Bold.

For example, assume task due dates are in B2:B100 and task statuses are in C2:C100. Select A2:C100 if the goal is to bold the whole task row. The formula below marks tasks with a due date before today that are not marked Paid:

With due dates in B2:B100 and statuses in C2:C100, and with the rule applied to A2:C100, use =AND($B2<>"",$B2<TODAY(),$C2<>"Paid"). A row dated yesterday with a status of Open meets the test and becomes bold; a row dated tomorrow does not. The blank-date check prevents empty due-date cells from being treated as overdue.

The dollar signs are important. In this example, $B fixes the test to column B and $C fixes it to column C, while the row number remains relative. As Excel evaluates each row in the selected range, it checks B2 and C2 for the first row, then B3 and C3 for the next. If you apply a formula rule to a different starting row, adjust the row numbers in the formula to match the first row of the selected range.

TODAY() updates with the current date when Excel recalculates the workbook. That makes the overdue test useful for ongoing lists, although a workbook may need recalculation before a date-based display refreshes. If you want a fixed cutoff rather than a moving date, use a date stored in a cell and refer to that cell in the rule.

Choose the right cells and references

Before building a rule, decide whether bold should apply to the tested cell, a separate result cell, or an entire record. Selecting only the value column is often clearest for a simple threshold. Selecting the full row is better when the important information is spread across several columns and the reader needs to identify the whole record.

Bold a cell based on its own value: select the value range and use a cell-value rule or a formula that refers to the first cell in that range.
Bold one column based on another: select the cells to format, then use a formula that tests the corresponding row in the other column.
Bold a full row: select the complete data area, lock the test column with a dollar sign, and leave the row number relative.
Skip headers: start the selection at the first data row so the heading does not receive the same formatting.

A frequent source of mistakes is starting the formula on a different row from the selected range. If the selection begins at row 2, a row-based test should usually refer to row 2 in the formula. Excel adjusts relative references across the range, so a mismatch can make the formatting appear one row too high or too low.

Manage rule priority and existing formatting

When more than one conditional formatting rule applies to the same cells, the rules can interact. Choose Home > Conditional Formatting > Manage Rules to inspect the rules and their Applies to ranges. In the Rules Manager, you can edit a rule, change its range, reorder rules, or remove rules that are no longer needed. Use the Show formatting rules for control to view rules for the current selection or the worksheet.

Rule order can matter when multiple rules set the same kind of formatting. For example, one rule might set a font color while another sets a fill. Excel may show both effects if they do not conflict, but competing rules that set the same property can produce results affected by priority and the Stop If True setting. If bold seems inconsistent, check whether another rule also controls font formatting and review the order.

Conditional formatting generally takes precedence over ordinary cell formatting for the properties controlled by the active rule. That means a manually applied font style may not look the way you expect while the conditional rule applies. Removing the rule does not erase the cell’s value, but it can change the appearance. Keep a copy of important workbooks before making broad rule changes, and use Manage Rules to check the Applies to range before editing or deleting a rule.

Common problems and how to fix them

If cells do not become bold, first check whether the condition is actually true. Confirm the comparison value, spelling, spaces, dates, and data types. A number stored as text, for example, may not behave like a numeric value in a comparison. For formula rules, test the logic in an empty worksheet cell if appropriate and check that the formula begins with an equals sign.

The wrong cells are bold: open Manage Rules and inspect Applies to. Also confirm that formula references align with the first row of the selected range.
Only some columns change: the rule may cover only part of the row, or the formula may use a relative column reference where a fixed column was needed.
Bold disappears after editing: the edit may have made the condition false, or another rule may now control the same formatting.
Nothing changes after setting the rule: verify that Bold was selected under Format > Font, then check the condition and the rule’s range.
Old rules keep affecting new data: use Manage Rules to expand or correct the Applies to range instead of creating overlapping duplicate rules.

For a formula that refers to text, check that the text in the cell matches the formula’s test. For example, a rule checking for the word Paid may not match a value with an extra space. For date rules, make sure the cells contain real Excel dates rather than date-looking text. These checks often explain formatting that appears random but is actually following the stored data precisely.

Conditional bold versus manual bold

Use conditional bold when the visual emphasis should follow changing data. It is especially useful in shared trackers, reports, and lists that are updated regularly. Use manual bold for fixed labels, headings, or editorial emphasis that should not change when values are edited.

Conditional formatting does not change the underlying data or make a cell’s value more important to Excel’s calculations. It is a display cue, not a data validation rule. A bold overdue task does not prevent someone from entering an invalid date, and a bold low-stock count does not automatically reorder inventory. If users need a visual signal plus a restriction or action, combine formatting with the appropriate data checks or workflow.

Excel for Microsoft 365 on Mac has conditional formatting tools with similar rule concepts, though dialog layouts and some controls can differ from Windows. In Excel for the web, many conditional formatting rules can be viewed and edited, but advanced rule management may be more limited or arranged differently. For detailed formula rules and managing a complex set of rules, use the desktop app when the web interface does not expose the control you need.

Frequently Asked Questions

Can Excel conditional formatting make text bold?
Yes. Edit or create a rule, choose Format, and select Bold on the Font tab. The font style is applied only while the rule’s condition is true.

Can I bold an entire row based on one cell?
Yes. Select the full data range, create a formula rule that tests the relevant column, and use a fixed column reference with a relative row reference. Make sure the formula’s row matches the first row in the selection.

Can conditional formatting bold only part of a cell’s text?
No. Standard conditional formatting formats the cell as a whole; it does not conditionally bold selected characters within a cell. For partial text emphasis, you must format the characters manually, or redesign the data so the part needing emphasis has its own cell.

Will conditional bold remain if I copy the cell?
It depends on what you copy and where you paste it. Copying cells can also copy conditional formatting rules, and relative references or Applies to ranges may adjust. After copying, check Manage Rules if the new range does not behave as expected.

Why does bold remain after I change the value?
Another rule may still be true, the conditional formatting range may include a different cell, or the bold may have been applied manually. Check Manage Rules and the cell’s direct font formatting to identify which source is responsible.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.