Format Cell Contents

This function is one of the format functions in SheetKraft. The others are FormatBorders.SK and FormatAsTable.SK To access these format functions, go to the more section and then the Format tab. (See figure)

The following guidelines describe how to format data as desired before exporting it.

Step 1:

Select the Cell Contents Button in the Format tab to open this dialogue box.

Step 2:

Choose the range of cells which have the desired formats to be applied to the data range.

Step 3:

Select the data range to which the format has to be applied.

The Precedent option is used if some other function has to be calculated before applying this format function.

The Conditions option is used if the format that is to be applied is conditional (Based on some criteria, some cells of the data range are not to be formatted). (shown in Figure)

Note: The range of the conditions should be of the same size as the data range.