Forum Discussion
Count cells in a row that has been coloured by Conditional Formatting
I didn't check with your file, errors are here
shall be >=0 or <=0 or like
correct is >=0
>=1 or <=1 or =1
This one have no syntax error, but yo shall to check the logic
=(K6="N")+ (L6>=-2)*(L6<=1)+ (M6>=1)*(M6<=10)+ (N6>=1)*(N6<=4)+ (O6<=0)*(O6>=1)+ (P6>=0)*(P6=0.5)+ (Q6>=-2)*(Q6<=4)+ (R6>=-2)*(R6<=1)+ (S6>=0)*(S6<=0)+ (T6>=1)*(T6<=30)+ (U6>=1)*(U6<=4)+ (V6>=1)*(V6<=2)+ (W6>=1)*(W6<=4)+ (X6>=1)+ (Y6>=1)*(Y6<=2)
Hi Sergei
I completed the formula hopefully correctly. When I put it into J6 I got an error message. I have uploaded it. I cannot see where I went wrong. This is the completed formula that I put into the cell.
=(K6="N")+(L6>=-2)*(L6<=1)+(M6>=1)*(M6<=10)+(N6>=1)*(N6<=4)+(O6<=0)*(O6>=1)+(P6>=<0)*(P6=0.5)+(Q6>=-2)*(Q6<=4)+(R6>=-2)*(R6<=1)+(S6=>0)*(S6<=0)+(T6>=1)*(T6<=30)+(U6>=1)*(U6<=4)+(V6>=1)*(V6<=2)+(W6>=1)*(W6<=4)+(X6>=<1)+(Y6>=1)*(Y6<=2)
Thanks for your help in sorting out my problem.
Regards. Chris
I didn't check with your file, errors are here
shall be >=0 or <=0 or like
correct is >=0
>=1 or <=1 or =1
This one have no syntax error, but yo shall to check the logic
=(K6="N")+
(L6>=-2)*(L6<=1)+
(M6>=1)*(M6<=10)+
(N6>=1)*(N6<=4)+
(O6<=0)*(O6>=1)+
(P6>=0)*(P6=0.5)+
(Q6>=-2)*(Q6<=4)+
(R6>=-2)*(R6<=1)+
(S6>=0)*(S6<=0)+
(T6>=1)*(T6<=30)+
(U6>=1)*(U6<=4)+
(V6>=1)*(V6<=2)+
(W6>=1)*(W6<=4)+
(X6>=1)+
(Y6>=1)*(Y6<=2)- Thanks for your help Sergei. it works great. Saves me having to physically count the cells now 🙂
Chris Sewley , you are welcome