Understanding Conditional Formatting Precedence Rules
The order that formatting rules are displayed in the List of Rules determines which formatting takes precedence.
If only global conditional formatting is used on your system, then cell formatting takes precedence over row formatting:
Cell Formatting
Global cell based formatting rules.
Row Formatting
Global row based formatting rules.
 
If both Global and Personal conditional formatting are used on your system, then the order of precedence is organized like this:
Cell Formatting
Personal cell based formatting rules.
Note: The ability to place personal rules before global rules is role based.
Global cell based formatting rules.
Personal cell based formatting rules.
Row Formatting
Personal row based formatting rules.
Note: The ability to place personal rules before global rules is role based.
Global row based formatting rules.
Personal row based formatting rules.
Quick Start for Effective Conditional Formatting
There is a lot of flexibility in how you apply conditional formatting. The following topics provide a selection of common conditional formatting tasks. It is not an exhaustive list, but designed to get you started with conditional formatting.