Conditional Coloring needs priority/ranking

Description

Conditional coloring is currently very limited with its logic. If I have 2 rules that apply a color to a row, then it doesn’t rank them, it only takes the most recent rule and applies that color to the row.

What are you trying to achieve

Design a ranking system for conditional coloring so different rules can apply in order of priority, not by most recent application of any of the rules.