Can I re-arrange the format rules, to change ...

(Frederik Munk Brønserud) #1

Can I re-arrange the format rules, to change the order of operations?

For example, if I have a “>5”-rule and a “>10”-rule, I want to make sure that a row matching both rules gets both icons, but the colour of the “>10” rule rather than the “>5”.

(Frederik Munk Brønserud) #2

Also, It would be nice if different icons (from different format rules) could have individual colours, instead of just the one, but that is more of a feature request than a question :slight_smile:

(Aleksi Alkio) #3

If you create two separate format rules with your validations, both icons will be showed. Which color you want to show, it depends what is the order on format rule table.

(Frederik Munk Brønserud) #4

@Aleksi_Alkio Great! How do I change the order?

(Aleksi Alkio) #5

If they are not in correct order, you need to recreate the other one (make a copy).

(Frederik Munk Brønserud) #6

@Aleksi_Alkio Ah, Okay. Not very intuitive, but doable. Thank you very much :slight_smile: