I have some code that tests for the use of color scales in conditional formatting but I'd like to check for the use of any icon set. The format condition for icon sets is XlIconSet but replacing xlColorScale with this gives me a type mismatch on the greater-than/less-than symbols <>.
Is there some other way to set this condition?
Works -> If ws.Cells.FormatConditions(CFRuleIndex).Type <> xlColorScale Then
Fails -> If ws.Cells.FormatConditions(CFRuleIndex).Type <> XlIconSet Then
Bookmarks