VBA Not Show Icon In Cell Of Conditional Formatted Icon Set

Al Del

Board Regular
Joined
Jan 9, 2007
Messages
112
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
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,099,788
Messages
5,470,788
Members
406,721
Latest member
Laiceyshae

This Week's Hot Topics

Top