Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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 04:11 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