There is a hierarchy in the CF conditions, so if you applied both those conditions to cell A1 in the order that you state, then A1 would appear yellow (if A1 > A2), even if A2 > A3. You might want to change the order of the conditions to get to see red as a priority.

Hope this helps.

Pete