Using LO 7.4.6.2. I may have missed something, but as I interpret the guidance for conditional formatting the choice is simply between one condition or another, eg greater/lesser. Maybe it is explained that way to make the principle simple to understand, but I want to format cells where there are 3 possible ranges of numbers (blood pressure readings, as it happens). Can anyone point me to the guidance for setting this up?
What you count as 2 conditions should better be seen as one (e.g GreaterThan) condition with its 2 possible results True and False (met, not met).
Only in rare cases you may need/want to create an extra condition for the opposite of a first one.
Using ConditionaFormat the listed conditons are evaluated top down, and the first one answering True gets its associated style applied and ends the sequence of evaluations.
[This was sketched as a comment, but then changed to a “solution”.
Site admins: Please stop silly checks.]
First check for p<130 and assign the cellStyleGreen to the case that it’s met.
Then add a condition p<160 assigning an appropriate cellStyle, and you may also add a third condition like p>=160 with its style.
You probably also want to play with the “all cells” variants of CF.
1 Like
And I thought I was constantly pushing the wrong thing. 
Jeff, I just had the same problem and just solved it. In my case its not bloodpressure but dates and my reference cells are on different sheets. I use 3 conditions to show the cell background in green, orange or red.
Codition1, Date is higher than: IF(TODAY()>$Sheet8.$B$3)
Condition2 Date is between two dates: AND((TODAY()>$Sheet8.$B$3);(TODAY()<($Sheet8.$B$3+5)))
Condition3 Date is more than today +5: IF(TODAY()>($Sheet8.$B$3+5))
Maybe not the most elegant but it works.