Below you can see my data (it's the German version, so the decimal point is a comma), already with the following conditional formatting rule applied:
=B21>=B22; it is applied to rows 21 to 28 (29 is excluded).
The intention is to highlight all cells in which the number doesn't get smaller compared to the cell below it. Looks good.
Now I want to add another condition: I also want to highlight cells where it decreases by more than 0.25 compared to the cell below. I use this formula:
=RUNDEN((B21-B22);2)<-0,25, which in the English version should be
=Round((B21-B22),2)<-0.25. It leads to the following result:
Now I'd like to combine these two with an
OR condition. This should combine the two pictures, right? It doesn't work, though. My condition is
=ODER(B21>=B22;RUNDEN((B21-B22);2)<-0,25) and in English that's
=OR(B21>=B22,ROUND((B21-B22),2)<-0.25). The result looks like
So all the cells with a "-" in them aren't highlighted. That's not an issue, in fact, that's what I want, but I don't see why this happens. Which means I don't completely understand what
OR is doing here or what mistake I made. Since I need to apply this to a lot of other sheets, I'd like to understand what is happening here.