How to Bold Specific Words Inside Excel Cells in Bulk (No VBA, No Macros)
Excel has no built-in way to bold, colour, or underline individual words inside cells at scale. Conditional Formatting? Cell-level only. Find & Replace? Can't apply formatting. VBA? Requires coding. Here's the free workaround that does it in seconds.
Quick Answer
Excel can format individual words inside a single cell (double-click → select → Ctrl+B), but there is no built-in way to do this across multiple cells at once. No online tool offers this either. SimpleTool's Keyword Formatter is the only browser-based tool that writes native Excel rich-text runs in bulk — for free, with no upload.
Bold, colour, or italicise specific keywords inside your Excel cells in bulk. 100% private — your file never leaves your computer.
Format Keywords NowThe problem: you need to highlight words, not cells
You have a spreadsheet with thousands of rows. Each cell contains a paragraph of text — audit findings, defect descriptions, contract clauses, meeting notes. You need the word “REJECT” to appear in red bold wherever it occurs, “PENDING” in orange, and “APPROVED” in green. Not the entire cell — just the word itself, so the surrounding text stays readable.
This is called partial-cell formatting (or “rich-text runs” in Excel's internal model). Excel supports it — you can see it when you manually format a single word inside a cell. But Excel provides no way to apply it in bulk. And as far as we can tell, no other online tool does either.
Here's what people try — and why each one falls short:
Three approaches that don't work (and why)
1. Conditional Formatting — colours the whole cell, not the word
Conditional Formatting is the first thing everyone tries. You set a rule like “if cell contains 'REJECT', format font as red bold.” It works — but it formats the entire cell. Every word in that cell turns red and bold, not just “REJECT.”
Conditional Formatting operates at the cell level. It was designed for visual flagging of cells (e.g. colour rows where status = “overdue”), not for word-level text formatting within cells. Microsoft has acknowledged this in their feedback forums but has not added sub-cell conditional formatting to any version of Excel.
2. Find & Replace — can find words but can't format them
Excel's Find & Replace dialog (Ctrl+H) has a “Format” button. You might expect it to let you find “REJECT” and replace it with a bold, red version of itself. It doesn't. The Format options in Find & Replace apply to the entire cellcontaining the match — same limitation as Conditional Formatting.
Some workarounds suggest using Find & Replace to wrap keywords in a marker (like **REJECT**) and then manually format later. This is just moving the problem downstream — you still can't format the word itself in bulk.
3. VBA macro — works, but most people can't write one
A VBA macro can do partial-cell formatting. It loops through cells, uses Characters(start, length).Font to apply styles to substrings, and handles multiple keywords. This is the technically correct Excel-native solution.
The problem: most people who need keyword formatting (auditors, ops managers, legal reviewers) don't write VBA. Even if you find a macro online, you need to paste it into the VBA editor, enable macros, save as .xlsm, and explain to your IT department why you're running unsigned macros. For a one-time formatting job, this is massive overkill.
Why no online tool offers this
If you search for “highlight keywords in Excel online,” you'll find tools that do cell-level formatting (Conditional Formatting generators), tools that convert between file formats, and tools that clean up data. None of them do partial-cell keyword formatting. Why?
It's technically hard
Partial-cell formatting requires writing rich-text runs into Excel's XML structure. Most spreadsheet libraries (SheetJS, openpyxl, Apache POI) support reading rich text, but writing it back correctly — especially when splitting a plain-text cell into multiple styled fragments — requires careful handling of the cell value model. Most online tools don't invest in this because the use case is niche.
It's confused with Conditional Formatting
Most users conflate “highlight a word” with “highlight a cell containing a word.” Conditional Formatting solves the second problem so well that tool builders assume the first is covered. It isn't — and the users who need word-level formatting (auditors, legal teams, QA) know the difference.
SimpleTool's Keyword Formatter was built specifically for this gap. It uses ExcelJS to read your workbook, splits every matching cell into rich-text fragments, applies font styles to each keyword occurrence, and writes a standard .xlsx with native rich-text runs. The output opens in Excel as if you had formatted every word by hand.
How to format keywords inside Excel cells (step-by-step)
- 1
Open the Keyword Formatter
Visit the SimpleTool Excel Keyword Formatter in your browser. No sign-up or download required.
- 2
Drop your Excel file
Drag and drop your .xlsx or .xlsm file. The file stays on your device — nothing is uploaded.
- 3
Add keywords and pick styles
Type each keyword you want to highlight. Choose bold, italic, underline, and a colour for each one. Add as many keywords as you need.
- 4
Click Format & Download
The tool scans every cell, finds your keywords, applies rich-text formatting to each match, and downloads a new .xlsx file. The original file is untouched.
Real-world examples: who needs this?
Internal audit teams
Highlighting "material weakness", "non-compliant", "significant deficiency" across 400+ finding rows before sending to the audit committee. Each term gets its own colour. The report looks professionally reviewed in seconds.
Legal reviewers
Colouring "shall not", "termination", "indemnify", and party names in contract clause exports. Partners receive the Excel with key language visually obvious — no PDF annotations needed.
QA / defect triage
Formatting "REJECT", "REWORK", "CRITICAL", "BLOCKER" in defect log exports from Jira or Azure DevOps. Engineering receives a scannable report with failure modes pre-categorised by colour.
Project managers
Bolding "EOD", "BLOCKED", "OVERDUE", "DECISION NEEDED" across a 200-row action register before the weekly status meeting. Urgent items pop instantly.
Template maintainers
Highlighting "[TBD]", "[FILL IN]", "PENDING REVIEW" placeholders in bright colour before distributing a template. Reviewers can see at a glance what still needs input.
Inventory & operations
Marking recalled lot numbers, expired SKU prefixes, or flagged supplier codes across a master inventory export. Warehouse staff get a visual guide without learning Excel filters.
Comparison: four ways to format keywords in Excel
| Capability | SimpleTool | Manual (Ctrl+B) | Conditional Formatting | VBA Macro |
|---|---|---|---|---|
| Formats words inside cells | Yes | Yes (one cell at a time) | No — whole cell only | Yes |
| Works across hundreds of cells | Yes | No | Yes (cell-level) | Yes |
| Multiple keywords with different colours | Yes | Tedious | Yes (cell-level) | Requires coding |
| No coding required | Yes | Yes | Yes | No |
| No Excel installation needed | Yes (browser) | No | No | No |
| Files stay private | Yes (no upload) | Yes | Yes | Yes |
| Setup time | 30 seconds | 5+ minutes per file | 2–3 minutes | 10–30 minutes |
| Output format | Standard .xlsx | Standard .xlsx | Standard .xlsx | .xlsm (macro) |
Only SimpleTool and VBA can apply word-level formatting in bulk. SimpleTool does it without coding or installing anything.
How it works under the hood
For the technically curious: Excel stores cell values either as plain strings or as rich-text runs — an array of {text, font} pairs. When you manually bold a word inside a cell, Excel converts the cell from a plain string to a rich-text run array behind the scenes.
What the tool does
- Reads your .xlsx file entirely in your browser using ExcelJS (JavaScript)
- For each string cell, searches for your keywords (case-insensitive)
- Splits the cell text into fragments: keyword matches and non-keyword segments
- Applies your chosen font styles (bold, italic, underline, colour) to the keyword fragments only
- Writes the fragments back as an Excel rich-text run array
- Outputs a new .xlsx file with native formatting — no macros, no external dependencies
The output is indistinguishable from a file you formatted by hand. Any application that reads .xlsx (Excel, LibreOffice, Numbers) will render the formatting natively. Your original file is never modified.
Frequently Asked Questions
Can Excel bold just one word inside a cell?
Yes, but only manually. You can double-click a cell, select a word, and press Ctrl+B. This applies a "rich-text run" to that cell. The problem is that there is no built-in way to do this across hundreds or thousands of cells at once. Conditional Formatting only styles entire cells, and Find & Replace cannot apply formatting. The only native bulk option is a VBA macro, which requires programming knowledge.
Why doesn't Conditional Formatting work for this?
Conditional Formatting operates at the cell level. It can change the background colour or font colour of an entire cell based on a rule (e.g., "if cell contains REJECT, make it red"), but it cannot format individual words within the cell while leaving the rest of the text unstyled. This is a fundamental limitation of the feature, not a configuration issue.
Is there a Find & Replace trick that applies formatting?
No. Excel's Find & Replace can change text content and whole-cell formatting (like font size), but it cannot apply bold, italic, or colour to just the matched substring within a cell. This is one of the most-requested features in the Excel feedback forums and has never been implemented.
Do I need to install anything or enable macros?
No. SimpleTool's Excel Keyword Formatter runs entirely in your web browser using JavaScript. No download, no installation, no macro permissions. The formatted output is a standard .xlsx file that opens normally in Excel, Google Sheets, and LibreOffice.
Is my spreadsheet data private?
Yes, 100%. The tool processes your file entirely inside your browser using your computer's memory. Your spreadsheet is never uploaded to any server. You can verify this by disconnecting from the internet after the page loads — the tool still works.
Can I apply different formatting to different keywords?
Yes. Each keyword gets its own combination of bold, italic, underline, and colour. A common pattern is "REJECT" in red bold, "PENDING" in orange italic, and "APPROVED" in green bold — all applied in a single pass.
Will the formatting survive if I open the file in Google Sheets?
Partially. Google Sheets imports .xlsx files but downgrades rich-text runs (partial-cell formatting) to whole-cell formatting on import. The formatting will display correctly in Excel for Windows, Excel for Mac, and LibreOffice Calc. If your downstream audience uses Google Sheets, the word-level formatting will not survive the import.
Stop formatting keywords one cell at a time
Drop your Excel file, type your keywords, pick your styles, and download a perfectly formatted workbook in seconds. Free, private, no sign-up.
Format Your Excel File Now