Count cells in a row that has been coloured by Conditional Formatting

Chris Sewley 

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)