![]() |
|
#1
|
|||
|
|||
![]()
So for the sub AmeberText() wd=Orange i have tweaked my original code to:
[Sub AmberText() Const wdOrange As Long = 41215 Dim r As Range Set r = ActiveDocument.Range With r.Find Do While .Execute(FindText:="Amber", MatchWholeWord:=True, Forward:=True) = True r.Cells(1).Shading.BackgroundPatternColor = wdOrange .Font.Color = wdOrange Loop End With End Sub] It will only colour the 1st "Amber" cell background to orange then it stops, any ideas on how to tweak it to change all the text Ambers the entire document? |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell text color vs cell background color | AC PORTA VIA | Excel Programming | 4 | 12-19-2018 04:01 PM |
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped | RaudelJr | Excel | 5 | 04-18-2017 11:11 PM |
Traffic light help needed | wmedjaxnjr | Excel | 1 | 04-08-2016 09:04 AM |
![]() |
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
![]() |
tatihulot | Excel | 4 | 08-14-2013 03:24 PM |