Skip to main content

Imagine you have a lot of conditional layouts that span the whole row, to indicate different statuses. In my case I have 5:

Screenshot with 5 different conditional layouts in random order

More than one condition can apply to a record simultaneously. Currently, it seems to just pick a consistent, but random, color when this happens. For example when a row both has mutated lines (red) and is paused (orange), it is colored orange. 

I’d like to apply an order of priority to the conditional layouts, so that I can define red as the more important status, forcing it to choose red over orange when both apply.

 

I’m aware I can also define the conditions in such a way that they will never overlap, but I would prefer not to do this, to keep their definitions clear and to the point. As you can imagine it would also become quite the DRY violation, getting worse the more conditions you add.

The following idea has been merged into this idea:

All the votes have been transferred into this idea.

MergedOpen

Interesting to add: 
At first I thought the alphabetical ordering wasn’t working (and it was in fact random), but I was just doing it the wrong way around.
Ordering it like this:

E will have the “highest” priority, since it is last checked, and will overwrite the previous color.

This works for my usecase!

A separate sequence number, and an optional setting to make conditions exclusive (as mentioned in the merged thread), would still be a welcome improvement.