Good Morning,

I have a userform into which the user can input parameters for conditional formatting on a table.

For example they can choose the value under which the cell will go red, and the value above which the cell will go green etc.

When they press OK to the userform, the values are put into a range of cells, which is what the conditional formatting goes by.

My only issue is that, when the values are changed, I have go in to conditional formatting and edit a rule and apply before it will update the rules with the new values.

So my question is how can I either build into my userform OK button macro to update conditional formatting, or how can I run the conditional formatting using VBA if that is easier?

I hope this makes sense