Conditional Format in VBA

[sdsurzh]

Hi,


Is it possible to run a conditional format in macros.


Thanks,

Suresh Kumar s

 

[Luke M]

Conditional Format is technically applied to cells, not "run", but yes, you can set them up or remove them via macros. Here's an example:

[pre]

Sub test()
With Range("A2")
'Add CF rule
.FormatConditions.Add Type:=xlExpression, Formula1:="=A1>1"
'Modify the rule's behavior
.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With .FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 255 'Red pattern
.TintAndShade = 0
End With

'Delete CF rule
.FormatConditions.Delete
End Sub

[/pre]

 

[sdsurzh]

Thanks Luke

 

[Luke M]

You're very welcome, thanks for the feedback.