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*.
1. Is that normal, or else I am doing something else incorrectly ? 2. Is a Boolean AND required/possible in the criteria settings? 3. Is the 3-criteria a limit for each Calc sheet? Please advise. Regards, VinceB.
