I am using the code below as part of a set of criteria to setup an Icon Set in a range N3:N200. Is there an option to not show the icon in the cell associated with IconCriteria(3) in the range N3:N200? With .FormatConditions(1) .SetFirstPriority .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl5Arrows) . . With .IconCriteria(3) .Type = xlConditionValueNumber .Value = 2 .Operator = xlGreaterEqual End With

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA Not Show Icon In Cell Of Conditional Formatted Icon Set

Thread starter Al Del
Start date Jul 24, 2018
Tags

.iconcriteria3 criteria end icon set

Al Del

Board Regular

Jul 24, 2018

I am using the code below as part of a set of criteria to setup an Icon Set in a range N3:N200. Is there an option to not show the icon in the cell associated with IconCriteria(3) in the range N3:N200?

Code:

      With .FormatConditions(1)
         .SetFirstPriority
         .ReverseOrder = False
         .ShowIconOnly = False
         .IconSet = ActiveWorkbook.IconSets(xl5Arrows)       
       .
       .
      With .IconCriteria(3)
            .Type = xlConditionValueNumber
            .Value = 2
            .Operator = xlGreaterEqual
       End With