Conditional Formatting options in Data-Viewer

Configuration Infographic	Return to Conditional Formatting

Infographic Icon
There are three available Color Scopes you can use when formatting data displayed in the Data-Viewer. If desired, you can mix the scopes if you have multiple rules defined.

Keep in mind:

Conditional formatting can be applied to both Parent and Nested data sets
If you are using Data Viewer 3.6 or earlier you will need to reset the formatting column(s) if the Column Display Settings screen is accessed after formatting rules have been defined.

NOTE: Resetting the conditional formatting column(s) is not required if you are using Data-Viewer 3.7. To find out what version you are using, click here

Color Scope options:

Color Scope drop down To apply conditional formatting, click the Conditional Formatting button under Data Analysis.

NOTE:
This requires you to have accessed the Data-Viewer Settings screens by clicking the Data Viewer Web Part Settings button in the web parts configuration tool pane.

Option	Configuration & Result
Text	Configuration: Result:
Cell	Configuration: Result: If you are going to format the cell, use a background color as shown above and pick a corresponding foreground color (text color) and style for the text so it is easy to read. Only the cells for the selected column will be formatted.
Row	Configuration: Result: If you are going to format the row, use a background color and not necessarily a text color or style. Text formatting (i.e., foreground color, style, font) will affect only the column identified in the rule (Task Status in the example above), while the background color will impact all columns displayed in the row. Be sure the background color selected works with the text of the other columns.

Option

Configuration & Result

Text

Configuration:
configured format example.png

Result:

Cell

Configuration:
format by cell2.png

Result:
format by cell2 result.png

If you are going to format the cell, use a background color as shown above and pick a corresponding foreground color (text color) and style for the text so it is easy to read. Only the cells for the selected column will be formatted.

Row

Configuration:
row format2.png

Result:
row format example.png

If you are going to format the row, use a background color and not necessarily a text color or style. Text formatting (i.e., foreground color, style, font) will affect only the column identified in the rule (Task Status in the example above), while the background color will impact all columns displayed in the row. Be sure the background color selected works with the text of the other columns.

Configuration Infographic	Return to Conditional Formatting