Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
Figure 4-2: The Highlight Cells Rules options apply formats if specific conditions are met.
The options in the Highlight Cells Rules category are pretty self-explanatory:
Greater Than: Allows you to conditionally format a cell whose value is greater than a
specified amount.
For instance, you can tell Excel to format those cells that contain a value greater than 50.
Less Than: Allows you to conditionally format a cell whose value is less than a specified
amount.
For instance, you can tell Excel to format those cells that contain a value less than 100.
Between: Allows you to conditionally format a cell whose value is between two given
amounts.
For example, you can tell Excel to format those cells that contain a value between 50
and 100.
Text That Contains: Allows you to conditionally format a cell whose contents contain any
form of a given text you specify as a criterion.
For example, you can tell Excel to format the cells that contain the text North .
A Date Occurring: Allows you to conditionally format a cell whose contents contain a date
occurring in a specified period relative to today’s date.
For example, Yesterday, Last Week, Last Month, Next Month, Next Week, and so on.
Duplicate Values: Allows you to conditionally format both duplicate values and unique
values in a given range of cells.
Search JabSto ::




Custom Search