VBA to Modify Conditional Formatting Text

Hi,
Is it possible to use VBA to modify conditional format text? For example, if the text is "xxx" change it to "yyy". This is the text value that triggers the conditional format. (Highlight Cells with Text that contains...) Any/all ranges on the sheet where it occurs.
Thank you.

The quickest way is just record a macro to do that. Start the recorder giev the macro a name and press Ctrl + H to open the find and replace box, enter the values and run it.
then stop the macro recorder.
Take a look at the vba code that has been generated and you've got an idea how it works and can edit at will.

Misunderstood; take a look at this link, maybe it will put you on the right track
https://support.microsoft.com/en-us/...you-use-vba-in

Why don't you attach a sample file with what you have and what you want.
You have to grasp the essential difference between conditional format and a cell content.

For example when you put a date into a cell you can format it to show day name month name year and everything but the value is still an unchanged date
The same with conditional format

if you want the cell containing xxx to color blue and zzz to color green that is the only thing conditional format does.
you have to manually or though another process change the content of that cell from xxx to zzz

So what you do is write macro that will check all the cells within a range that have the value xxx and change it to zzz the conditional format if applied to that range will change accordingly

Hope I have been able to explain my thoughts in a way that they help you solve this

True, you do not and cannot modify text using Conditional formatting. The word says it; conditional formatting, change of text is not a condition

To be clear, I don't want to modify the text in the cell that is being conditionally formatted, I want to modify the text string in the conditional format rule.

This is a small (relevant) portion of what you get when you record a macro.
Where you see "CHANGE THIS TEXT", that is what I want to change. I need to change it in 100s of rules but I'm testing on 1 cell at the moment.

    Selection.FormatConditions(1).StopIfTrue = False
    Range("E16").Select
    Selection.FormatConditions.Add Type:=xlTextString, String:= _
        "CHANGE THIS TEXT", TextOperator:=xlContains
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
    End With

CF.PNG
This does nothing

ActiveSheet.Range("e16").FormatConditions(1) _
 .Modify xlTextString, Text, "=TEST CHANGE TEXT"