Update Conditional formating (1 Viewer)

pekajo

Registered User.
Local time
Today, 22:57
Joined
Jul 25, 2011
Messages
124
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

1647242110312.png
 

sonic8

AWF VIP
Local time
Today, 14:57
Joined
Oct 27, 2015
Messages
612
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

Super Moderator
Staff member
Local time
Today, 08:57
Joined
Feb 19, 2002
Messages
36,889
If the controls are all on the same form, you can select them all and change the properties as a group.
 

Users who are viewing this thread

Top Bottom