Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-13-2025, 12:21 AM
Kawax Kawax is offline how to change color of part of a cell text Windows 10 how to change color of part of a cell text Office 2016
Novice
how to change color of part of a cell text
 
Join Date: Sep 2025
Posts: 1
Kawax is on a distinguished road
Lightbulb how to change color of part of a cell text

Hello,




I have tables with cells containing letters, for instance :


Cell (1,1) = "A B F H"
Cell (1,2) = "C F R"


I want to color each letter in red or in black individually, based on a criteria that I apply from other cells content.


For instance, in cell 1, F would be colored black, the other letters red. In cell 2, F would red, etc. => the color of the letters can differ from cell to cell.


I'm more or less able to navigate through cells and return information but I can't find how to change the color of these characters, as Characters collections is read only and Cells seems to work differently than in Excel. Unfortunately, I can't leave the Word environment due to other constraints (complex layout)


I saw in another thread https://www.msofficeforums.com/word-...xt-within.html that Find can be used. In my case I guess it won't work as the color of a letter can be each time different in cell 1, 2, 3, 4 ?


Many thanks for your suggestions,


JM
Reply With Quote
  #2  
Old 09-13-2025, 05:42 AM
Italophile Italophile is offline how to change color of part of a cell text Windows 11 how to change color of part of a cell text Office 2021
Expert
 
Join Date: Mar 2022
Posts: 554
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Characters is not read only. See Characters object (Word) | Microsoft Learn
Reply With Quote
  #3  
Old 09-13-2025, 05:55 AM
Charles Kenyon Charles Kenyon is offline how to change color of part of a cell text Windows 11 how to change color of part of a cell text Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Conditional formatting is far stronger in Excel than in Word.
You can do this with complex, nested, IF Fields.
Reply With Quote
Reply

Tags
cell formatting, cell value, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to change color of part of a cell text Why is part of text's background is white color and I can't change it? mrMad-Cat Word 2 05-03-2022 02:33 AM
Drop down fields in Word - Change color of cell, then add text BernaDev202 Word VBA 3 08-09-2018 02:29 PM
how to change color of part of a cell text How to change the font color of specific text within a Word table cell epid011 Word Tables 2 05-15-2017 05:21 PM
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped RaudelJr Excel 5 04-18-2017 11:11 PM
Change a part of date or the number color Jazzis Excel 3 10-15-2016 01:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft