Conditional Formatting - Query

Can any one explain why a number of zero's within the shaded range (blue) are not formatting as crosses?
Supplier-Partnership-Criteria.xlsx
robmarr700Asked:
Who is Participating?
 
ProfessorJimJamCommented:
i have replaced all of "0" which actual zero 0  

attached is the file and is now working as you wanted it.
Supplier-Partnership-Criteria.xlsx
0
 
ProfessorJimJamCommented:
becuase they are not acctually zeros. they are zero which is put in a form of text which is inside double qoutes
0
 
Glenn RayExcel VBA DeveloperCommented:
ProfessorJimJam is correct; those are the alphanumeric character "0", not zero.

You have to change your formulas on the combined sheet (insert and then copy formulas down):
O2: =IF(OR(TRIM(N2)="undetermined",N2<=0),1,0)
Q2: =IF(OR(TRIM(P2)="undetermine",P2<=50),1,0)
Z2: =IF(OR(TRIM(Y2)="undetermined",Y2>=40),1,0)

-Glenn
0
 
robmarr700Author Commented:
Thanks Guy's well spotted.

Rob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.