In a previous article, Conditional Formatting within mTAB™'s Spreadsheet view 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.

 

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.

 

Conditional Formatting - Auto Legend