×

Multiple conditional formatting

  • US 7,634,717 B2
  • Filed: 01/23/2006
  • Issued: 12/15/2009
  • Est. Priority Date: 01/23/2006
  • Status: Active Grant
First Claim
Patent Images

1. A method for applying multiple conditional formatting rules to a plurality of data cells in a user interface, the method comprising:

  • identifying with a computing device a first conditional formatting rule as having a highest priority of a plurality of conditional formatting rules, the first conditional formatting rule including a first condition type, at least a first parameter, and a first formatting;

    determining with the computing device a first set of data cells in the user interface that are associated with the first conditional formatting rule;

    for each data cell in the first set of data cells;

    determining with the computing device whether the data cell should be evaluated;

    if determined that the data cell should be evaluated, evaluating the data cell with the computing device to determine if the first conditional formatting rule is TRUE;

    if determined that the first conditional formatting rule is TRUE,determining with the computing device whether the first formatting conflicts with previously applied formatting for the data cell; and

    if determined that the first formatting does not conflict with previously applied formatting, applying with the computing device the first formatting to the data cell;

    identifying with the computing device a second conditional formatting rule as having a next highest priority of a plurality of conditional formatting rules, the second conditional formatting rule including a second condition type, at least a second parameter, and a second formatting;

    determining with the computing device a second set of data cells in the user interface that are associated with the second conditional formatting rule, wherein at least a first data cell in the second set of data cells is also in the first set of data cells and wherein at least a second data cell in the second set of data cells is not in the first set of data cells;

    for each data cell in the second set of data cells;

    determining with the computing device whether the data cell should be evaluated;

    if determined that the data cell should be evaluated, evaluating with the computing device the data cell to determine if the second conditional formatting rule is TRUE;

    if determined that the second conditional formatting rule is TRUE, determining with the computing device whether the second formatting conflicts with previously applied formatting for the data cell; and

    if determined that the second formatting does not conflict with previously applied formatting, applying with the computing device the second formatting to the data cell;

    wherein when the first and second conditional formatting rules are determined to be TRUE for the first data cell and when the first and second formatting does not conflict with previously applied formatting for the first data cell, the first formatting and the second formatting are both applied to the first data cell.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×