Difference between revisions of "Conditional formatting - Auto Legend"
m (Mtabadmin moved page Auto Legend to Conditional formatting - Auto Legend without leaving a redirect) |
|||
| Line 1: | Line 1: | ||
| − | + | In a previous article, [[Applying a conditional format]] we discussed the benefits of the Conditional Formatting system in the mTAB environment. Through the use of this function, it is possible for the analyst to call out items of interest through the use of color. | |
| + | |||
| + | |||
| + | While in the Conditional formatting dialog, the "Show Applied Formatting" box at the bottom, displays a full listing of all formatting that has been applied. | ||
| + | |||
| + | [[File:Conditional-formatting_auto-legend_conditional-formatting.jpg|x250px]] | ||
| + | |||
| + | Once in the spreadsheet however, it was not immediately apparent what each color denoted. | ||
| + | |||
| + | [[File: | ||
| + | |||
| + | The Auto Legend function takes care of this by placing a legend at the bottom of the spreadsheet, listing each of the colors and describing the numeric range to which it is applied. | ||
| + | |||
| + | [[File: | ||
| + | |||
| + | Exporting the spreadsheet to an Excel File places this same legend at the bottom of the exported file. | ||
| + | |||
| + | [[File: | ||
| + | |||
| + | And the same is true when the spreadsheet is exported in HTML format. | ||
| + | |||
| + | [[File: | ||
Revision as of 12:11, 5 August 2013
In a previous article, Applying a conditional format we discussed the benefits of the Conditional Formatting system in the mTAB environment. Through the use of this function, it is possible for the analyst to call out items of interest through the use of color.
While in the Conditional formatting dialog, the "Show Applied Formatting" box at the bottom, displays a full listing of all formatting that has been applied.
Once in the spreadsheet however, it was not immediately apparent what each color denoted.
[[File:
The Auto Legend function takes care of this by placing a legend at the bottom of the spreadsheet, listing each of the colors and describing the numeric range to which it is applied.
[[File:
Exporting the spreadsheet to an Excel File places this same legend at the bottom of the exported file.
[[File:
And the same is true when the spreadsheet is exported in HTML format.
[[File:
