Conditional Formatting Rules Evaluation and Conflict Resolution
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data visualization tools, such as spreadsheets, are limited in their ability to apply multiple conditional formatting rules to cells, as they can only evaluate conditions to TRUE or FALSE and apply a single format, with no additional formatting applied once a condition is met, and are restricted to a maximum of three conditional formats per cell.
Innovation Solution
A method and system for applying and evaluating an unlimited number of conditional formatting rules to a range of cells, allowing multiple rules to be evaluated and formats applied simultaneously, with prioritization to prevent conflicts and enable more complex formatting based on cell values, such as changing background color or icon selection.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a maximum of three conditional formats are applied to a cell, then the system maintains simplicity and fast processing, but the ability to represent nuanced data conditions is limited
Solution Approach 1:
The patent segments conditional formatting into rules with different priorities (high, medium, low). Instead of treating all formats equally with a hard limit of three, the system divides formats into priority levels, allowing multiple formats to coexist by evaluating them in hierarchical order. This segmentation resolves the contradiction by enabling more than three formats while maintaining systematic control through priority-based evaluation.
Solution Approach 2:
The patent adds a priority dimension to conditional formatting evaluation. Rather than simply counting the number of formats applied, the system introduces a hierarchical dimension where formats are evaluated based on their priority level. This allows unlimited formats to be applied by considering their position in the priority hierarchy, effectively resolving the limitation of three formats per cell.
2Adaptability or versatility
If only one format is applied per cell, then processing is simple and fast, but multiple data conditions cannot be represented simultaneously
Solution Approach 1:
The patent performs preliminary evaluation of all conditional formatting rules before applying formats. All rules are assessed against the cell value first, determining which rules apply, and then formats are applied based on this pre-determined set. This preliminary action allows multiple formats to be applied efficiently without repeated evaluation overhead, resolving the contradiction between representing multiple conditions and maintaining processing speed.
3Adaptability or versatility
If conditional formatting rules are evaluated in a limited sequence, then processing is efficient, but complex formatting scenarios with multiple True conditions cannot be handled
Solution Approach 1:
The patent implements dynamic rule evaluation based on priority levels. Instead of a fixed evaluation sequence, the system dynamically determines which rules to evaluate and apply based on their priority assignments. High-priority rules are evaluated and applied first, followed by medium and low-priority rules, allowing the evaluation mechanism to adapt to the specific formatting scenario and handle multiple True conditions effectively.
Data Source
AI summary
Generally described, embodiments of the present invention relate to applying and evaluating conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell.