Tip #2001-4: Using Excel's Conditional Formatting
Excel's conditional formatting adds a powerful dimension to displaying
and viewing real-time data by calling attention to conditions
or trends. Conditional formatting means that the display of
the data changes if a certain condition is met. For example,
you could have a cell display red text on a yellow background
if the cell's value falls below a certain level.
In the example below, we have a worksheet that brings in the last
price for several instruments and compares it to the year's
high. If the ratio is under 0.5, we want to be alerted that
the instrument is trading at less than half of its year high.
When this condition occurs, the cell's font and cell background
are formatted differently. This lets you quickly identify these
distressed securities.
The two functions mentioned in this tip are actually part of an Excel Add-In. You must
load the Add-In to use the functions.
How can I do it myself?
|
