Excel's conditional formatting options allow you to apply different formatting options, such as background color, borders, or font formatting to data that meets certain conditions.
Overdue dates, for example, can be formatted to show up
with a red background or a green font color or both.
Conditional formatting is applied to one or more cells
and, when the data in those cells meet the condition or conditions specified,
the chosen formats are applied.
Starting with Excel 2007, Excel has a number of pre-set
conditional formatting options that make it easy to apply commonly used
conditions to data.
These pre-set options include finding numbers that are
above or below the average value for the selected range of data.
No comments:
Post a Comment