[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

Modifying Conditional Format from VBA code

I need to modify the Maximum Value for a Conditional format.

Edit Formatting Rule
How can I accomplish this within VBA code?
0
Terry Rogers
Asked:
Terry Rogers
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try
Sub macro3()
    Range("I3").FormatConditions(1).MaxPoint.Modify newtype:=xlConditionValueNumber, newvalue:=100
End Sub

Open in new window

Regards
0
 
Rob HensonIT & Database AssistantCommented:
Rather than modifying to a specific number, modify it to refer to a cell. You can then just adjust the value in the cell when you need to modify the value.
0
 
Terry RogersIT Senior EngineerAuthor Commented:
Thank you, this worked as expected. :)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now