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)

img1


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.

img2


Step 2:

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

img3


Step 3:

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

img4


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)

img5


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

img6