Excel-vba: Conditional Formatting: Cell Style

Question

I'm trying to use the .style function in this formatting, but vba doesn't want to use it. Am I just using the .style wrong or do I need to use a different method to color the cells?

'Conditional Formatting
.FormatConditions.Delete
.FormatConditions.Add xlErrorsCondition, Formula1:= _
    "=IF(" & Cells(SelectedGroup, AreaSelected(2)).Offset(2, 1) & "=""Not Used"",TRUE, _ 
    FALSE)"
.FormatConditions(1).Style = "Bad"

.FormatConditions.Add xlErrorsCondition, Formula1:= _ 
    "=IF(" & Cells(SelectedGroup, AreaSelected(2)).Offset(2, 1) & "=""Used"",TRUE,FALSE)"
.FormatConditions(1).Style = "Good"

According to this, style isn't a method for formatcondition: msdn.microsoft.com/en-us/vba/excel-vba/articles/… — a-burge
– a-burge, Commented Sep 15, 2017 at 13:19

a-burge · Accepted Answer · 2017-09-15 13:22:54Z

1

Style is a property of the Range object. In order to use it, you need to end your With statement and apply the style to the Range itself.

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-style-property-excel

answered Sep 15, 2017 at 13:22

a-burge

1,6242 gold badges18 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel-vba: Conditional Formatting: Cell Style

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related