Conditional Formatting - Stop if True - Turning On/Off

I have the following code:

Please Login or Register  to view this content.

All of the CF rules have "Stop If True" applied. Is there any way to turn this off by default, and add SiT to individual rules?

You can specify it with the StopIfTrue property

Please Login or Register  to view this content.

What would be more efficient / better written?

As you have suggested, or

Please Login or Register  to view this content.

and calling this in my Sub CF()?

I don't think that will work because StopIfTrue is a property of the Format Condition not the cell.

I have amended my code for my Macro

Please Login or Register  to view this content.

When I apply the Macro, CF is removed, all is added as per the code. In my data, J4 contains "Yes" but the CF for F4 is applied, even though F4 is .StopIfTrue = False and J4 is .StopIfTrue = True and the relevant tick-box is empty/ticked according to the macro

Oh my lord

Thank you. Both

Maybe you could separate out the creation part to make it less long and only change the parts you need to.

Please Login or Register  to view this content.

Thanks for the help, BM