Hi all,
I have found how to count conditional formatting colors when the conditional format is set with a simple formula like =A3>50 or A3=37... but when I change the formula to the classic IF(AND to change the color when the values are not within specific values, then it doesn't work. Even if I change the simple formula adding decimals for example =A3>50,46 it won't work either. See the attached example please.
Is there a way to make the function count properly the colors from conditional formatting by using the formula as it is in the attached example with green color?
Thank you all in advance for your help!
Bookmarks