At 21:46 25/01/2017 -0500, Vince Bonly wrote:
Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in detecting scores above a threshold (>174) and marking the cell for red font for a specified range of cells. That uses 1 of the 3 available criteria settings. Next, I tried setting a criteria setting (condition 2 of 3) for the same range of cells to apply a bold font whenever scores are >199. Thus, for example, a score of 225 would have both red and bold applied to the cell. It seems that Calc is unable to set a 2nd or 3rd criteria over *the same range of cells*.
By experiment, I see that is not true: you can achieve what you want. Unfortunately, you don't explain exactly what you have done and what result you see, so anyone is left to guess.
Conditional formatting works by applying cell styles. You talk about applying "both red and bold", but you cannot apply two styles simultaneously to the same cell or cell range, of course. So you would need one cell style for red and another for red-bold. (The criteria you wish to apply are such that you don't need bold without red.) Is that what you did?
All that's left is to notice the built-in help text, which says _inter alia_ "The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated." (This doesn't appear to be explained in the Calc Guide.) Note those words "Otherwise" and "If ... not": if any condition is satisfied, later ones are disregarded. In your case, if you apply the >174 condition first, the >199 condition will be evaluated only if the value is not >174 - so can never be effective. The solution is just to set >199 with red-bold as Condition 1 and >174 with red as Condition 2.
Is a Boolean AND required/possible in the criteria settings?
Not if you are using "Cell value is", I think.
Is the 3-criteria a limit for each Calc sheet?
No: it's a limit for any individual cell, I think. However you construct your cell ranges, each cell has its own set of up to three conditions.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
