Add conditional format icons to cells in VBA - 2007

[skimo]

Hi,

My objective is just to add an icon to a cell (the icons in the excel 2007 conditional format) regardless of its value (string, number..). I am trying to do this in VBA.

Is control of these icons exposed somewhere in the "Range" object? Or do I have to create a "fake" conditional format on that cell to make it display the icon? (ps - even that I have not been able to get to work for a single Text cell).

Any help would be appreciated!

Thanks in advance
Skimo

 

[skimo]

I tried this using several approaches but I am really giving up! Any ideas?

 

[VoG]

I really have no idea but this might be a start http://www.microsoft.com/downloads/...25-93E8-4ED4-8385-74D0F7661318&displaylang=en