Update Conditional formating (1 Viewer)

pekajo

Registered User.
Local time
Today, 12:26
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, 04:26
Joined
Oct 27, 2015
Messages
593
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
Yesterday, 22:26
Joined
Feb 19, 2002
Messages
36,296
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