Hey.

I already searched around a lot but didn't find an appropriate answer to my problem.
The thing is...

1.) I have a collum which is already conditionally formatted (see code below)

Please Login or Register  to view this content.

ok so far so good.


2.) now i want to create a loop to identify all cells in this range which are formatted with the colorscalecriteria(3) - highest value and write into a new collum a "1" if the criteria is fulfilled if not the value should be "0".
i tried this with using the following code which doesn't work.


Please Login or Register  to view this content.



Please help me to find an appropriate solution for this problem. Thank you in advance!