Please help solve a problem of conditional formatting
[Users questions | Browse:50 | Favorites]
Users questions: I need a few column values for conditional formatting, meaning that if the value of the fractional part of the first two (both decimal 10) the number of 0 to set the color to reflect; example, suppose the value in a1, I use conditional formatting formula is = (a1 "")*( a1 0 )*(** right (Int (a1 * 100)) = 0) becomes red. But some value (looks), such as 3.01,2.99, etc. These, the first 10 decimal places is not a value of 0, conditional formatting color changed red. Ask President, this is what causes; what formula (method) can be To solve this problem. That is, the first 10 decimal places is 0 only changes the value, instead of 0 does not change. Description: The series is calculated in the return value of the data, that objective more than two decimal places on the thank you
Experts answer: decile formula is modified as follows: = MID (A1, S EARCH (".", A1) +1,1) = "0" percentile formula is modified as follows: = MID (A1, SEARCH (".", A1) +2,1) = "0"
Experts answer: decile formula is modified as follows: = MID (A1, S EARCH (".", A1) +1,1) = "0" percentile formula is modified as follows: = MID (A1, SEARCH (".", A1) +2,1) = "0"
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.