VBA to Modify Conditional Formatting Text

[ker9]

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.

[Keebellah]

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.

[ker9]

When you do that it records every single conditional format that exists as well as the one that you change. It's very specific to cell, etc. I was trying to find a way to use modify but really struggling with it.

[Keebellah]

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

[ker9]

It would appear that you can format the appearance but I cannot find a method to modify the text.

https://msdn.microsoft.com/en-us/vba...n-object-excel

[Keebellah]

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

[Keebellah]

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

[ker9]

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.

Please Login or Register  to view this content.

CF.PNG
This does nothing

Please Login or Register  to view this content.