Hey.

Conditional formattings have apparently an order in which they're evaluated.

This becomes obvious when e.g. multiple formattings change the styles of the same range.
I actually use that behaviour quite often in more complex formattings.

The problem is, that from the dialogue at Format / Conditional / Manage, it's not possible to change their order (and the dialogue doesn't even seem to show their real order).

What I do then is to delete the right one of the "conflicting" conditional formattings, and re-create it as a new one with exactly the same settings. And voila, the behaviour on the spreadsheet changes.


Would be nice if the dialogue would:
- show their real order
- had up/down buttons to move the entries.


Thanks,
Chris.