Conditional Format all Cells in one Col by referncing cells in another Col using IconSets

[amq]

Hi,

Far from a short title, but very concisive.

I want to format every cell in Col "C" using IconSets under the condition that the corresponding Cell value in Col "A" is larger/similar/lower.

There is a code-snipped that I used so far, and most surprisingly it works only sometimes

Please Login or Register  to view this content.

* Reason why i run this cell by cell is that i don't see another possibility of setting the values dynamically. If there is a way so I can just define this over the entire column please tell - I'd love to!

If i only run this through a short range, say 3-4 cells, it seems to work. If i run this over an entire column.... it doesnt and everything gets flagged red.

How can I fix this?

Best regards,
Andreas

[arlu1201]

Is this the entire code? Do you have the sample file which you are using along with this code?

[amq]

This is the entire code in this function. I have loads of other code which, however, shouldn't affect this.

I copied everthing to a new workbook so you can follow it - same behavior here.

Thanks for your help!

BRegs,
Andreas

[amq]

Any more ideas? Thank you very much!