Mass change conditional format conditions

So imagine you have a sheet with lots of different conditional formats in them. And some of those formats are based on a certain condition or are partly based on that condition.

what I want to be able to do is loop through all the conditional formats in the sheet and find that string within the conditional format condition and replace it (as opposed to going into every conditional format one at a time or clearing and redesigning my conditional formats.

So for a basic example -

maybe my cells is red when A1+B1+C1>0 But now A1+B1 need to be D1
i.e. in this case it creates D1+C1>0

Conceptually this is what i am imagining (although you can tell me if I'm approaching this wrong)

msgbox enter string1
msgbox enter string2
for each FormatCondition in sheet
look at the condition and find string1
replace string1 with string2 (or record failure as I imagine error checking might be a good idea)
next condition
confirm completed or if there was an error

See if this is what you are looking for:

Please Login or Register  to view this content.

thanks,
however I mean that the formula is IN the conditional formatting rules,
and it is the rules that I want to edit not the formulas in the cells themselves.

ie the data that appears under
conditional formatting -> manage rules - > edit rule -> under "format values where this formula is true"

It can be assumed that the conditional formats will always be in the "if this formula is true" format, if that helps.

I just found something that looks like it does the job
although I modified it to use the special cells like your example (and I suppose I'll also loop through the format conditions rather than just doing 3)

Please Login or Register  to view this content.

http://blog.livedoor.jp/andrewe/arch...at_103343.html