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
Formula:
=IF(AND(A3>=$M$1;A3<=$M$2);0;1)
as it is in the attached example with green color?
Thank you all in advance for your help!
Bookmarks