Difference between revisions of "Conditional formatting - Auto Legend"
| Line 1: | Line 1: | ||
| − | In | + | In the 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 | + | While in the Conditional formatting dialog, the '''Show Applied Formatting''' box displays a full listing of all formatting that has been applied. |
:::[[File:Conditional-formatting auto-legend condtional-formatting.jpg|x300px]] | :::[[File:Conditional-formatting auto-legend condtional-formatting.jpg|x300px]] | ||
| − | + | However, it was not immediately apparent what each color denoted in the spreadsheet. | |
:::[[File:Cond-formatting auto-legend cond-format-spreadsheet.jpg|x35opx]] | :::[[File:Cond-formatting auto-legend cond-format-spreadsheet.jpg|x35opx]] | ||
Revision as of 11:38, 5 August 2013
In the 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 displays a full listing of all formatting that has been applied.
However, it was not immediately apparent what each color denoted in the spreadsheet.
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.
Exporting the spreadsheet to an Excel File places this same legend at the bottom of the exported file.
And the same is true when the spreadsheet is exported in HTML format.
