Which takes priority when a sheet has 2 conditional formatting rules?

When a sheet has multiple conditional formatting rules, the rule that is positioned at the top takes priority over those below it. This means that if there are conflicting conditions between the rules, the formatting defined by the top rule will be applied in cases where both rules are applicable.

This prioritization is important in managing how data appears based on various criteria, as it allows users to control which rule is enforced first. For example, if one rule specifies a certain format for a specific condition and a subsequent rule adjusts that format under another condition, the first rule at the top will determine the final appearance in cases of conflict.

Understanding this hierarchy helps users to set up their formatting effectively, ensuring that the intended visual cues are displayed as desired based on the conditions of the data in the sheet.