Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Conditional Formatting - Query

Posted on 2014-10-17
Medium Priority
80 Views
Can any one explain why a number of zero's within the shaded range (blue) are not formatting as crosses?
Supplier-Partnership-Criteria.xlsx
0
Question by:robmarr700
• 2

LVL 27

Expert Comment

ID: 40386879
becuase they are not acctually zeros. they are zero which is put in a form of text which is inside double qoutes
0

LVL 27

Assisted Solution

Glenn Ray earned 800 total points
ID: 40386891
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

LVL 27

Accepted Solution

ProfessorJimJam earned 1200 total points
ID: 40386896
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

Author Comment

ID: 40386903
Thanks Guy's well spotted.

Rob
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
###### Suggested Courses
Course of the Month11 days, 19 hours left to enroll