Conditional formatting - Auto Legend
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.