conditional formatting

Object properties can either have a fixed value or a conditional formatting.

Conditional Formatting can be used to change the appearance or visibility of objects based on values in the form.

Charts are fancier, and "conditional formatting" automatically applies color to cells whose numbers meet certain criteria.

Pivot tables and conditional formatting are not yet supported but are planned for future versions.

User Roles can customize a user's experience by changing views or using conditional formatting based on the identity of the user.

Adding data validation, using validation formulae, and conditional formatting features without manually writing code.

PivotTables can also be sorted and filtered independently, and conditional formatting used to highlight trends in the data.

Forms Server 2007 hosted forms support data validation and conditional formatting, as does their InfoPath counterpart.

Microsoft Excel 2007 introduced the functionality to render Harvey Balls through the Conditional Formatting function.

Calc fully supports the conditional formatting of Excel 97-2003 and version 3 or later also supports the 2007 version of Microsoft's software.

This version introduced a quick-start screen, conditional formatting, fluid layout auto-resizing, hyperlinked pointers into databases, and external SQL links.

FrontPage 2003 introduced conditional formatting, Find and Replace for HTML elements, new tools for creating and formatting tables and cells, dynamic templates (Dreamweaver), Flash support, WebDAV and SharePoint publishing among other features.