Ask a question format condition
[Users questions | Browse:86 | Favorites]
Users questions: A1, A2, A3 **- these three cell values - are 0.97191.03860.8761 conditional formatting I want to set two conditions for 1: If the cell value of 1, red 2: If the value of 1 conditions, the numerical minimum green. I also set conditional formatting First: = a1 = MIN (IF ($ a1: $ a3 1, $ a1: $ a3)) turns green, the second: = a1 1, red ---- in practice, only a , red; when 1; MIN, they were not green I do not know where is wrong - my exce l of the document set the basic number of decimal places is two, please take a look; Thank you actual examples above the middle of 1.0386 ,0.97191.03860.8761 ---- 1, it should be red; right 0.8761 a minimum, should have been green
Experts answer: set a good formula, Please see the following table accessories: Book1.xls
Experts answer: set a good formula, Please see the following table accessories: Book1.xls
- 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.