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)
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 help me to find an appropriate solution for this problem. Thank you in advance!
Bookmarks