1. A method for evaluating a plurality of conditional formatting rules applied to a user interface, the method comprising: identifying first and second conditional formatting rules for formatting cells in a user interface, wherein the first conditional formatting rule has a first priority and a first formatting, wherein the second conditional formatting rule has a second priority and a second formatting, and wherein the first priority is greater than the second priority; identifying a cell contained in the user interface associated with the first and second conditional formatting rules; determining with the computing device if the first and second conditional formatting rules are satisfied for the cell; and if determined that the first and second conditional formatting rules are satisfied, applying the first formatting to the cell based on the ranking of the first priority and determining whether the second formatting and the first formatting belong to a single group of conflicting formats prior to applying the second formatting associated with the second conditional formatting rule.