One click conditional formatting method and system for software programs
First Claim
1. A method of conditionally formatting a display of data comprising:
- identifying one or more parameters of the data to be conditionally formatted on the display;
selecting a predetermined condition; and
automatically applying temporarily the predetermined condition to the parameter in a predetermined format; and
displaying a temporary preview on the display of the predetermined format applied to one or more of the parameters that meet the predetermined condition.
3 Assignments
0 Petitions
Accused Products
Abstract
A method of conditionally formatting a display of data is disclosed that involves providing a preliminary display automatically showing the intended consequences of the condition applied to the data prior to making the condition actually apply to the data. This is especially useful in analysis of spreadsheet data by conditionally formatting certain data. The method involves identifying one or more parameters of the data to be conditionally formatted on the display, selecting a predetermined condition; and automatically applying temporarily the predetermined condition to the parameter(s), displaying a temporary preview on the display of the predetermined condition applied to data that meet the predetermined condition. The method also provides the capability to preliminarily change the conditions and parameters applied to the data and automatically provide appropriate previews of the effect of such application of changed conditions on the displayed data.
-
Citations
28 Claims
-
1. A method of conditionally formatting a display of data comprising:
-
identifying one or more parameters of the data to be conditionally formatted on the display;
selecting a predetermined condition; and
automatically applying temporarily the predetermined condition to the parameter in a predetermined format; and
displaying a temporary preview on the display of the predetermined format applied to one or more of the parameters that meet the predetermined condition. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A computer program product readable by a computer and encoding instructions for executing a computer process for displaying spreadsheet data using conditional formatting, the process comprising:
-
identifying one or more parameters to be conditionally formatted on the display;
selecting a predetermined condition;
automatically applying temporarily the predetermined condition in a predetermined format to the parameter;
automatically displaying a temporary preview on the display of the predetermined format applied to one or more of the parameters that meet the predetermined condition. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21)
-
-
22. A graphical user interface for a program operable on a computer system, the graphical user interface having a display module for displaying data, said graphical user interface comprising:
-
a selection module for identifying data to be conditionally formatted on the display;
a condition module providing a set of predetermined conditions;
a format module providing a set of predetermined formats;
a preview module automatically applying temporarily a selected one of the predetermined formats to data meeting a selected one of the predetermined conditions and automatically displaying a temporary preview on the display of the data using the predetermined format applied to the parameter that meets the predetermined condition. - View Dependent Claims (23, 24, 25, 26, 27, 28)
-
Specification