Conditional format iconset

[Emm]

Hi All,

I've looked everywhere but cant seem to find code to conditional format an Incon set.

All I need is code for a conditional format on a selected range.
I want to use the (xl3Symbols2) with an input of 1 for Tick, 0 for Cross, and the ! for anything else.

Can someone point me in the right direction.

Thanks,

Keith

 

[Jerry Sullivan]

Keith,

You could make that work with a formula-based rule provided that the values are always numeric.
As far as I know you can't get a CF Icon (like the !) appear in a cell that has a non-numeric value.

If you sometimes have text, you might consider placing the icons in the adjacent cells.