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

Frederik
Participant V

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”.

0 5 329
5 REPLIES 5

Frederik
Participant V

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

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
Participant V

@Aleksi_Alkio Great! How do I change the order?

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

Frederik
Participant V

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

Top Labels in this Space