Update Conditional formating

[pekajo]

Hi,
Is there a vba way of changing the conditional formatting expression.
I want to change [MonC] = 1,2,3 .. on each of the conditions to [TueC] = 1,2,3 ..

Thanks for any help
Peter

 

[June7]

Yes, VBA can dynamically modify Conditional Formatting rules. However, if you want to permanently change the rule saved with form or report, object would have to be opened in Design view then saved with edits. https://www.access-programmers.co.u...nd-for-format-conditions-limited-to-3.271679/

 

[sonic8]

Is there a vba way of changing the conditional formatting expression.

Yes, the ComboBox and TextBox controls have got a FormatConditions collection that contains all that data including the Expressions.

 

[Pat Hartman]

If the controls are all on the same form, you can select them all and change the properties as a group.