How to change font color on string/text values

[wences309]

I have cells with titles in which some words are black, others are red/
struck through, and other words are blue.

For every cell that has blue words, I want to convert those words to
green. All other words in the string should remain, as is.

Any ideas? I tried this conditional formatting:

Cell Value is EQUAL TO = "vbBlue" [format..] then I clicked a green
color.

Thanks!
Dan

 

[Al Campagna]

Dan,
vbColor Constants are pretty limited. I suggest using the RGB function.

I set up a text control named Test with Black text (RGB 0,0,0)
I entered the following ControlSource in another text control...


=IFF(Test.ForeColor = RGB(0,0,0), "Test Black", Test not Black")
In C/F that would be...
Expression Is Test.ForeColor = RGB(0,0,0)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."