You can manage the rules for conditional formatting. This means, for example, that you can change the order in which the rules are applied.
Procedure
Open a spreadsheet.
Activate the Contents tab bar.
Select the relevant spreadsheet area which has conditional formatting or for which you want to create conditional formatting.
Click Conditional formatting > Manage rules. The dialog opens.
Specify the relevant settings and click OK.
You have edited your rules or created new ones.